Hi,
I have a excel 2010 sheet with approx 32,000 rows of customer addresses and job ID numbers. I want to delete duplicate addresses but concatenate job ID numbers. I need to find the duplicates, concatenate the adjacent cells and then remove duplicates.
Example:
Column A | Column B
45 Park Avenue| 99675
45 Park Avenue| 99870
91 Bay Street | 54678
74 Main Street | 65478
74 Main Street | 67456
Result:
Column A | Column B
45 Park Avenue| 99675, 99870
91 Bay Street | 54678
74 Main Street | 65478, 67456
I have searched a lot of threads, nothing so far fits exactly what I am trying to do, I am a fairly novice user
Is this possible? THANKS!
Bookmarks