I would like to create a function, and subsequently a macro that would solve the following issue:
Column A has IDs with many duplicates. Column B has details for each ID in A. Column B's content is from standardized responses, so for each ID, there may be many responses, and these responses appear repeatedly through Column B.
Example:
Column A | Column B
12345 Cat
12345 Dog
12345 Bird
67890 Cat
67890 Bird
I would like to combine the contents of Column B for each ID into one cell.
Example:
Column A | Column B
12345 Cat, Dog, Bird
67890 Cat, Bird
I understand the function of =B2 & ", " & B3 & ", " & B4, but the trick here is to automate it for hundreds of IDs and thousands of lines such that for instances of duplicates in the ID column A, it runs the formula/script to combine the contents of B into one cell for adjacent to the ID, deleting the duplicate rows containing the IDs and their B data (now combined into one cell in the remaining row for the ID).
Please help, you'd save me literally about 2.5 hours a week for work.
Bookmarks