As is often the case, we receive a data set where the format of the data was designed for readability and not usability.
What I mean is, the data is in a finished presentation-state where modifications like sorting, filtering, charting, etc. are not expected to be performed.
What are you supposed to do with this report if you need to manipulate it beyond its delivered format?
We’ve seen in a previous post how we can take cross-tabular data (headings in rows and columns) and unpivot the data into a traditional tabular/table format.
But what about a cross-tabular data set with multi-row headers? The process gets a bit more involved, but it is still no match for the superpowers of Power Query.