I need help with VBA code to perform a complex sort. Basically, I have a column of names, each with one or more duplicates, and many columns of colors. Each column represents a different color. For each name (and duplicates) in column A, there may be one or more associated colors. The same name may have one color, and the same name in the next row may have another. So, I need VBA code that will find and all colors for each unique name and place them in a column.
See the attached file for a clearer picture. Test Case - Data Manipulation.xlsx
*Please note that I have a much larger file with way more names and colors. This is just a sample.
I have tried many different ways, but without success. Any help would be greatly appreciated.
Bookmarks