May 10, 2019
First of all thanks for a great web site Mynda, there are so many out there but yours is one of the best.
I've been googling the web and looked through your excellent post and video regarding unpivoting, but has still not been able to solve my problem. I have received a pivot table with data (no access to the source data) and want to unpivot the data I receive to be able to build other views on the data. My problem I'm not able to solve is that the Pivot table is showing three "layers" for the rows. Attached is a file with dummy data showing how it look, and what I'm looking for.
Probably an easy task for you skilled people, but still a challenge for a Power Query newbie.
July 16, 2010
This is a unique case and since there is no consistent pattern you can't use the typical Unpivot technqiues.
I created a table that contained the country and town details and then merged it with the source data to 'lookup' the country and town data that could then be 'filled down'. See file attached.