Forum Discussion
Merging Dups but keeping certain data
I'm trying to figure out how to merge duplicate rows but I only want certain data. How do I do that? Example: Here are two rows, the second row only has email and phone number. I want all the data ...
Hello Merrilily7,
I would suggest using a Pivot table with the following layout:
- Subtotals: Do Not Show Subtotals
- Grand Totals: Off for Rows and Columns
- Report Layout: Show in Tabular Form
- Blank Rows: Remove Blank Line after Each Item