Table Re-organisations

[lidderdj]

Hi, 

I have a table with the following data (amongst others):

I'd like to create a new table from these columns with the following format:

I'm at a complete loss about how to achieve this, so any assistance woulfd be greatly apreciated.         

[anandav · Accepted solution]

@lidderdj,

You will need to use the Unpivot functionality in Power BI.

In Query Editor you will select the ID column and from 'Tranform' tab select 'Unpivot Columns' --> 'Unpivot Other Columns'

[lidderdj]

Brilliant. Thank you so much for your swift reply! That's a really elegant solution for something I've been trying to write a DAX code for!