Transposing multiple duplicate rows to a single row with multiple columns

[victoriaw2160]

We've been attempting to convert an Excel sheet with two columns of duplicate information spread across multiple rows into a single row with the duplicate information removed.

We think this existing code found for a similar project could work well with a bit of modification. It's able to take duplicate rows from the first column and combine them into a single row, but unfortunately it does not then do the same for a second column with duplicate information, instead including the duplicate information in the newly outputted row.

I was wondering if someone had suggestions on how to tweak this existing code so it can provide the desired results? It would be greatly appreciated!

Here's a sample of the workbook.

Please Login or Register  to view this content.

Thanks to ExtendOffice for this sample.

[jindon]

Not sure what you are trying to do.
Just my guess.

Please Login or Register  to view this content.

[victoriaw2160]

Thank you so much jindon, that is what I was looking for