You add a column for the combined values and then group if you want to combine those values further into a single record.

When you want to combine values in Microsoft Excel, instead of complex expressions or VBA, opt for Power Query – it’s fast and easy.

Add multiple columns in Google Sheets You certainly don’t have to add just one column at a time if you need to insert more. You can add multiple columns at once just as easily.

Use Power Tools to split the text into columns Google Sheets Use the Power Tools add-on if you want more control over splitting text into columns in Google Sheets.