Excel Gurus,
I am in the middle of a massive project and have no idea how to use VBA. I have this function below that will do what I need, but I don't know how to curtail it to run on my spreadsheet. Cells need to be changed to mine? Ranges? Help!
My worksheet: All data in Cols A and B on Sheet1, 30k lines, need to consolidate! Note: data is not actually just numbers and letters, its text strings where Col A has many file names (repeating 2-250+ times each, Col B is list of data contained in said file)
Data format I currently have:
Desired format:
This is the function I was given that should get the job done, but I don't know what I need to do to get it to run in my worksheet.
Can anyone help me? I'm in a huge bind and need to get this finished before 9am ;( What do I need to edit in the function, and how do I run it in my worksheet?
Gurus, save me!
Bookmarks