Forum Discussion
Solved
Unpivot / Merge Columns
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?
7 Replies
the best way to do this is in Power Query Editor
Can you please share your demo input and expected output!
don't forget to change the excel file address
