How should I go about getting VBA to look through an array, see that a repeat is in there and then have it combine the repeats into a list?
If ... value in cell is not unique in the column (sans header of course)... then store values to the left to then be joined with a delimiter in another column.
I don't need to preserve colors, column widths, or any other formatting. I thought I'd use household products as the data I am actually using is abstract and may not get the idea across as well. Here is the workbook I took the above screenshot from: Source and Product.xlsx
Is this task going to be best approached through making a dictionary or a collection? Or something else? I haven't used either before. I'm just getting ok with loops and arrays in general.
Also, the order in which the sources appear do not necessarily need to be maintained either.
Thanks in advance!