Hello
I am sure this has been raised before but I have no idea what to search for. I will do my best to explain what I am trying to do. (let me know if I should post this in another location).
I'll use arbitrary data for the explanation.
Lets say I have 10 columns, each has a letter label (A,B,C,D etc)
Each column is full of random (non sequential) numeric values (103,223,556,773,101)
The are many multiples listings for the numeric values in different columns, so 103 may be in B E and L. 809 may be in A, B, C and E.
I am trying to take this data and list all of the numeric values in a sequential list with the next column listing what Letter values they are associated with.
So, if 809 was listed in the columns A, B and E I wanted organise the data so it looks like
809 | A,B,E
Is this possible to do? I should point out that the numbers are product codes (letters and numbers) and the letter values are 'categories' for a website.
Thanks
Jon
Bookmarks