Forum Discussion
Merging Data Based on Duplicate Cell Data
Hello all. I have a spreadsheet with well over 60,000 rows of data that were pulled from three separate sources. Several rows have the same account number, but the remaining fields for that row are...
jmurphy2020 I think what you want might be achieved using a pivot table where you group the data based on Account No. You can also use custom fields in the pivot table creation if you need to process the data to be displayed. I wish I could be more specific / helpful but without a file it is hard.