CSV googly|Power Query|Excel Forum|My Online Training Hub

Hi Guys,

I have just been thrown a googly from one of our suppliers they're using a new system that stacks csv file as in the example when you do a multiple download, I know how to get the header information out and combine with the detail on a normal single download one but not one that's stacked like this.

I have highlighted the info I need and saved as an xls although it downloads as a csv.

First line in red needs to be filtered as Confirmation or Amendment header detail in green needs to be added to the line detail in blue.

There can be up to 12 depot/PO headers (green) and 15 product lines (blue) for each header.

I hope someone can help 🙂