PQ-transpose data from several lines to one column
| 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
