BEFORE Value
Column1 Column2 Column3
546
546
546
546
547
547
547
547
548
548
548
548
549
549
549
549
511
511
511
511
512
512
512
512
546
547
548
549
511
512
546
547
548
549
511
512


Code:
// Table1
let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    Trans = Table.Transpose(Source),
    Space = Table.AddColumn(Trans, "Custom", each " "),
    UNP = Table.UnpivotOtherColumns(Space, {}, "Attribute", "Value"),
    RLN = Table.RemoveLastN(UNP,1),
    RV = Table.ReplaceValue(RLN," ",null,Replacer.ReplaceValue,{"Value"}),
    RC = Table.RemoveColumns(RV,{"Attribute"})
in
    RC