Forum Discussion
Convert excel matrix table to flattened table
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.
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 are most welcome. I am just a learner like you. If my reply helped, please mark it as Answer.