Forum Discussion

Mic1979's avatar
Mic1979
Icon for Post Partisan rankPost 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...
Need Help
  • jgeddes's avatar
    jgeddes
    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.

     

slorin's avatar
slorin
Icon for Super User rankSuper User
1 year ago

Hi Mic1979 

Combine Columns + Expand

 

let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("DcY3DQAwEARBLlebhHM2gdfzp+EtRhozRQUlZBRUNHR5MA02sbBxcPHk/gE=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Column1 = _t, Column2 = _t, Column3 = _t, Column4 = _t, Column5 = _t, Column6 = _t, Column7 = _t]),
CombineColumns = Table.CombineColumns(Source,{"Column5", "Column6", "Column7"},each _,"New_Column"),
Expand = Table.ExpandListColumn(CombineColumns, "New_Column")
in
Expand

Stéphane