Coloum to row

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


Code for Power Query:

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"})
#"Split Column by Delimiter"


Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies