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.
Hi Space,
Have you resolved your issue? If so, please kindly mark the corresponding reply as an answer so that some other users can find the solution more easily. If you still have any question, please feel free to ask.
Best regards,
Yuliana Gu