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 add a highlight to expose groups in your Microsoft Excel data using a helper column and Excel’s conditional formatting feature.