Forum Discussion
Convert excel matrix table to flattened table
The Excel tables that I receive for import into Power BI always have data arranged as a matrix. Where is a good place that I can learn how to convert a matrix into a flattened table? I've fou...
Hi,
Instead of having 2 rows for every column, have just one. So row 2 should have Year, DHB, Maori - Enrolled, Maori - Populaiton etc. Once that is done, take the data to the Query Editor, right click on the first 2 columns and select Unpivot other columns. You may then split the attribute column by the - delimiter.
Hope this helps.
Ashish_Mathur You Sir, are a legend!!! OMG your solution worked! Thank you soooooooooo much!
You’re a Power BI Expert!!! Best wishes!
You’re a Power BI Expert!!! Best wishes!
You are most welcome. I am just a learner like you. If my reply helped, please mark it as Answer.