Hello!
I am currently working on a document, which has 5500 rows of data, which has anywhere from 2-5 rows of duplicates of the same user. Although the row may be for the same user, each row has different data which needs to be combined in the same column and not lost. I've been trying to find some basic VBA code online, but I can't find any that works.
Sample is attached. Ideally, I'd like to have all of John's data in one row, and all of Sally's data in one row.
Many thanks!
Bookmarks