Forum Discussion
Solved
Import crosstab spreadsheet
Hi can anyone give some advice on how to import a cross tab formatted table from Excel into Power BI so it can be used to create new visualisations please? i.e. State 1999 2000 2001 200...
Space You can load the data as is, then once it is loaded, go to Edit Queries, select all the year rows, right click and select Unpivot Columns, this will pull all the years into a single column and the values corresponding to them. I assume this is the output you expect.
Space You can load the data as is, then once it is loaded, go to Edit Queries, select all the year rows, right click and select Unpivot Columns, this will pull all the years into a single column and the values corresponding to them. I assume this is the output you expect.