Home

Coloum to row

ansonea32
Occasional Visitor
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"

 

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
21 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies