Hi,
I've got 3000+ rows of data, in which duplicate (and triplicate, quadruplicate... etc) rows (@ column A) are present. I want to get rid of those extra rows and the data on them moved to a single row.
The values in duplicate rows are never on the same column.
Here's sample data on one sheet. The upper table shows an example of "before" and the lower one is an example of "after".
Sample_data_vba.xlsx
Regards,
Sagwa
Bookmarks