Import crosstab spreadsheet

Question

Hi can anyone give some advice on how to import a cross tab formatted table from Excel into&nbsp; Power BI so it can be used to create new visualisations please?&nbsp;i.e.State&nbsp;&nbsp;&nbsp; 1999&nbsp;&nbsp; 2000&nbsp;&nbsp; 2001&nbsp; 2002Vic&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 7&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 23NSW&nbsp;&nbsp;&nbsp; 15&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 6&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 43QLD&nbsp;&nbsp;&nbsp; 34&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 12&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 52&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 7

anonymous · Accepted Answer

Space&nbsp;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.

Forum Discussion

Import crosstab spreadsheet

2 Replies

Related content

Excel spreadsheet not importing all rows

Import SharePoint Spreadsheet Through Python Script in Power BI

Limit columns of import from a spreadsheet

Google spreadsheet integration

Tidying excel spreadsheet in power query