Forum Discussion
Mic1979
Post Partisan
Post PartisanShift 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...
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.
