Its OK I puzzled it out simply promoted headers before splitting into depot and PO then unpivot and split
Hi Guys, Thanks for all the replies so far but one key thing is missing the date in the first row isn't irrelevant. If you look at the result cs...
Awesome Mynda thank you just need to convert to use Folder.Files and a work around for some of the header names
Doh!!! I didnt even realise I had made it a table Thanks guys
Hi Phil, I thought there might be a watch window or something I could set to trace dependants etc. Its just formatted to "mmm" @velouria I j...
Hi Mynda, very strange as soon as I change anything in the query, it uploads the headers as dates and throws it all out of sync I've attached bo...
Hi Thanks for replying but I think I fixed it in the third merge query in the screenshot is a column called merge2 I was deleting in in the next step....