I have a list as follows...
Form A Category 1
Form D Category 2
Form A Category 3
Form B Category 1
Form B Category 2
Form C Category 3
I would like the Output to be....
Form A : Category 1; Category 3
Form B: Category 1; Category 2
Form C: Category 3
Form D: Category 2
This could be in another table, or on the same line. I am moving it into another program. I tried this code, but it doesn't work for me, I ended up with all 0.
I tried this one, but it gave an error about a loop, or a number being wrong...
In the first article, I am unsure what the author means by uniquelist. Is this a feature in excel, or is he just naming the cell/column? I have 5876 rows of data, so in the first example I changed the 19s to 5876.
In the second example I made a similar adjustment.