Okay, I think this is probably easy, but I can't figure it out. Half the problem is that I'm not entirely sure how to phrase it.
What I want to do is to take a number of items in a column and put them in a cell, belonging to a certain ID.
So, the data looks like this:
ID Cert
10056 MS1
10056 MS3
10056 MS2
I want the finished product to look like this:
ID Cert
10056 MS1;MS3;MS2
The order of the certs doesn't matter.
Bookmarks