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

Want to organize all the worksheets in your Excel workbook? Try creating a table of contents. It makes it easy to find specific sheets, especially if your Excel file contains hundreds of them.

Notes High Sierra: How to add a column to a table Click anywhere in the column next to where you want the new column to appear. It can be to the left or right of where you want the new column.