PQ-transpose data from several lines to one column

[sandy666]

BEFOREValue

Column1Column2Column3
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



// 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