I am trying to consolidate multiple records into a single row as follows:
For each unique entry in column A, I want to consolidate all the various inputs in column B into a single cell separated by commas. I would then repeat the process for column C and finally column D.
The image below illustrates what I am attempting to do.
Consolidate.jpg
Bookmarks