Forum

Which Excel version are you on?

The attached file contains two possible solutions. One that begins with a traditional UNPIVOT step, then one merge with the Search table. Filter out t...

Thanks, but I don't see a file. Did you press the "Upload" button?

Perhaps you can upload a small data set demonstrating what you have in mind. Raw data as you would find it in the 5 million row table, the table with ...

Perhaps the example in the attached file will help you create the script you need. If not, you can perhaps upload a sample of your real data, though n...

Perhaps not the prettiest solution, but with Power query you can first "flatten" the data. Then do a few minot transformations and load everything bac...

Perhaps clear in your mind, but please upload the work you have done so far. Then it becomes much easier to diagnose and fix the problem.

You write that the steps you need to perform repeatedly are: 1) select column, 2) right click "split column", 3) select custom and enter "]",...

Glad you like the proposed solution. Perhaps, I'm not the best to judge what macros can do. Personally, I'm not very good with them and have learned I...

It depends a little bit on how accustomed you are with PQ, but when you look at the queries in the file, you should be able to follow the applied step...

Although you specifically asked for a macro/VBA solution, I would like you to consider PowerQuery for a task like this. It's relatively easy to extrac...

Thanks, but this PDF contains no data that is recognised by PQ. I suspect that it is merely a scanned document or a screenshot of a document exported ...

Thanks, but you attached a Word document with a screenshot of a PowerQuery window. Difficult to help if you don't upload the PDF as well.

The attachment didn't come through. Please try again and don't forget to press the "Start Upload" button before you submit your reply.

Great! Well done.