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

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.