Thank you both Mynda and Philip - you're rockstars. Philip your data matched what I was able to come up with and I couldn't be happier. Also, Mynda, y...
I'm pretty sure I was able to solve the problem by taking the source data, and pivoting it so all the dates were in one column and all the regions in ...
With regards to the column count issue, it seems a limit of 140 was hard-coded into the Source step. I've learned that removing that section fixes the...
Thank you both for responding. I'm really hoping I can keep the file light and handle most (if not all) of the work in Power Query, but I'll trust you...
Thank you both for your replies. Catalin I was able to get your code working in my file and it was pretty close, but it still wasn't able to to begin ...
Hi, just wondering if anyone's had a chance to look into this. I hate to be a bother and waste time. I have a feeling I'm doing the only thing possibl...
Oh, sorry my apologies!
My first attachment was not even created properly. Please look at this one as well to get an idea of what I'm really attempting to achieve. Thanks aga...
I did find a solution from that sort of worked, but not quite. let Source = Excel.CurrentWorkbook(){[Name="Table3"]}[Content], Grp = Table.Group...