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.
Hi,
I have a similar query with the data but wanted to automate the process as I receive daily data which needs to be updated. How can I query this?
and wanted to transform it into the following way:
Hi,
Your input data is in very bad shape. It may take a lot of effort to get it in your desired format. It may not be an easy task.