Unpivot / Merge Columns

[azakir]

Hi Guys. 

I've got an excel file that I am trying to pull into Power BI. The file has a number of "Merged" columns in Excel: 

I would like a single column for dates, a single column for either "staff" or "wages" through Power Query Editor. Or is there an easier way to do this? 

[Ahmedx]

don't forget to change the excel file address

[Ahmedx · Accepted solution]

pls try this

Sample PBIX file attached

https://1drv.ms/u/s!AiUZ0Ws7G26RiEIEJnzOhtQqU1p0?e=HW88We

[azakir]

Thanks @Ahmedx That did the trick for me. 

[Ahmedx]

Can you please share your demo input and expected output!

[azakir]

Hi @Ahmedx 

https://file.io/DPCxcJrtrxty

Here's the link to the file. Expected outcome is below: 

[Ahmedx]

the best way to do this is in Power Query Editor

[azakir]

Thanks @Ahmedx . Exactly, would like to know how