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

Learn how to split one column into multiple columns in Excel. Use Text to Columns and Delimited options and use Delimiters to separate data in Excel.

You can add a column in Excel by right-clicking or using the “Insert” option. These features are helpful for adding new data to a spreadsheet.