Cleaning up "merged" cells from Excel based data

[sjhand]

I have massaged some data from an excel documents with some merged columns and simplified it to the screenshot below.

The second and third columns (HRS and Postpaid) are related by date, so are the 4th and 5th columns, and so on.....

What I am trying to accomplish is to promote HRS and Postpaid to the header and move the date (which is the header for HRS) into its own column.

I want to do this for every single date in the data. Currently, there is only one instance of each store with dates going horizontally. The end result should show me one HRS and one Postpaid column with dates going vertically and as many instances of a store as there are dates.

Hopefully that made sense. I think that the ask is simple enough but I may not have explained it well. Let me know. THanks in advance!

[lbendlin]

You said you have simplified it.  I don't see that 😞

Please provide sanitized sample data that fully covers your issue. If you paste the data into a table in your post or use one of the file services it will be easier to assist you. I cannot use screenshots of your source data.

Please show the expected outcome based on the sample data you provided. Screenshots of the expected outcome are ok.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523