Forum Discussion

Mic1979's avatar
Mic1979
Post Partisan
1 year ago
Solved

Shift Down all the columns in a table dynamically

Dear all,   I have a table (the one on the top) and I would like to have the transformation as the one in the bottom     It is a matter of shifting all the rows down. Could you help? Tha...
  • jgeddes's avatar
    1 year ago

    You can use Table.UnpivotOtherColumns for this.
    Select the first four columns of your table.

     

    On the 'Transform' ribbon choose 'Unpivot Columns' / 'Unpivot Other Columns'.

    Delete the created 'Attribute' column.