I'm using a program which exports a series of 8 tags in a random order in one column (new row for each entry) as seen below:
Each tag has a predefined value ranging from 3 -48 options per tag.
tag 1 could be one of: canada, usa, mexico, etc..
tag 2 could be one of: small, medium, large, extra large, etc..
Is there anyway to arrange the information so that all tags are organized properly? (All of the tag1's are in one column, tag2's in another, etc..).
I would appreciate any help with this, as I've been struggling to find a solution elsewhere. Let me know if you would like me to provide any additional information.
Thanks in advance,