Hi Excel experts!
I have similar data spread across multiple rows that I would like to combine. Below is a simplified example:
r15Yz2x.jpg
I want to combine all of the names in column D, comma delimited, if they have the same information from other rows in columns A, B, and C. For example, Column A, B, and C of rows 2, 3, and 4 say Pizza, http://www.pizza.com, 1/12/2014. The difference comes in Column D of rows 2, 3, and 4. I would like to consolidate all of the names in Coilumn D that pertain to the information from the first three columns. Here is an example:
1JP9KS6.jpg
How can I accomplish this? Please see attached a sample workbook for the example I have created. My actual data is very large (1000+ rows)
Example.xlsx
Bookmarks