I'm looking for a method to flip my information around. Instead of Cell A listing corresponding words in column B, I've been tasked with finding all the unique words in Column B and listing all the A cells which correspond.
This is what I am working with below. I have DOCUMENT names running down column A. I have 25,000 lines. The DOCUMENT cells are document names in my real world. Column B cells are technically "tags" for my documents. These tags are separated with commas. These can be delimited across the row if easier to work with.
DOCUMENT-000001|dog,cat,ball,purple,9er,TEST 123,thanks
DOCUMENT-000002|dog,purple,thanks
DOCUMENT-000007|cat,ball,9er,TEST 123
This is how I will ultimately need the data presented. Column A is all the unique values which were previously comma delimited in the above Column B. Then next to each of those tags I need to list each of the document names which were in the previous Column A, in the corresponding cell of all the tags.
dog|DOCUMENT-000001,DOCUMENT-000002
cat|DOCUMENT-000001,DOCUMENT-000007
ball|DOCUMENT-000001
purple|DOCUMENT-000001,DOCUMENT-000002,DOCUMENT-000007
9er|DOCUMENT-000001,DOCUMENT-000007
TEST 123|DOCUMENT-000001,DOCUMENT-000007
thanks|DOCUMENT-000001,DOCUMENT-000002
Manually parsing this data isn't too practical for me. I have 25,000 lines and, if delimited, there are hundreds of unique tags. Some rows have every single tags, some have half of those tags, some only have one or two which makes manual sorting so daunting.
I'm looking for some VBA help. I've had great experiences here in the past learning VBA which I have used daily in my work. I'm looking for anything which can help me. Sample code, a link to a website explaining how to perform one component of the overall macro, or even if you're to say "try this" and say the name of something for me to google. I appreciate any of your help.
I'll respond quickly if you require any additional information or if you need me to do something. I've attached an example xlsx. It's just the above information on two sheets. Thank you for your time!
Bookmarks