Thanks Riny, thats perfect, I still get confused with unpivoting etc
Hi, This has been working fine until a third page was added, now the transform sample file (2) is blank and the query gives a couple of errors E...
Thanks Catalin, I can't get my customers IT team to change for now so I do as you suggested wrote a macro to update all to xlsx and going forward w...
@Catalin I just downloaded it from here to check and the file attached above 20210112-Daily.xls has the same data in AE1 and AE16 there is a LEN f...
Update I still can't get it to work unless the first row has more than 255 chars in every file I was hoping that it would work with the sample file...
I have cleaned the files as much as possible but there are some extra queries I couldnt delete. daily file is the data file I added the bits in yel...
Thanks Anders for now I can't change the registry due to corporate policies. I tried adding a row to the sample file that Power Query uses with 100...
Thanks Anders, I missed counting the brackets, end result was a missing { and a missing ) in case anyone else is looking and want to rename the las...