Import crosstab spreadsheet

[Space]

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  2002

Vic       10       5         7        23

NSW    15       6         3        43

QLD    34       12       52       7

[v-yulgu-msft]

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

[Seth_C_Bauer · Accepted solution]

@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.