Coloum to row

Copper Contributor
I have attached screenshot, can you help me to make desired table(yellow) from actual table(blue).
1 Reply

@ansonea32 

Code for Power Query:

let
Source = Excel.CurrentWorkbook(){[Name="Tabelle1"]}[Content],
#"Changed Type" = Table.TransformColumnTypes(Source,{{"actual", type text}, {"row", type text}}),
#"Grouped Rows" = Table.Group(#"Changed Type", {"actual"}, {{"AllData", each _, type table}}),
#"Added Custom" = Table.AddColumn(#"Grouped Rows", "Values", each [AllData][row]),
#"Extracted Values" = Table.TransformColumns(#"Added Custom", {"Values", each Text.Combine(List.Transform(_, Text.From), ","), type text}),
#"Removed Columns" = Table.RemoveColumns(#"Extracted Values",{"AllData"}),
#"Split Column by Delimiter" = Table.SplitColumn(#"Removed Columns", "Values", Splitter.SplitTextByDelimiter(",", QuoteStyle.Csv), {"Values.1", "Values.2"})
in
#"Split Column by Delimiter"