Forum Discussion
Solved
how to reshape data
Hi, I am new to data reshaping. I have attached a link to a sample spreadsheet which has a raw data worksheet which I'd like to reshape to look like the second worksheet, Desired Output. I don't car...
Use this please
let Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content], #"Pivoted Column" = Table.Pivot(Source, List.Distinct(Source[Role]), "Role", "Participant"), Custom1 = Table.TransformColumnNames(#"Pivoted Column", each Text.Proper(_)) in Custom1
A simple pivot should do the trick
let
Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
#"Pivoted Column" = Table.Pivot(Source, List.Transform(List.Distinct(Source[Role]), each Text.Proper(_)), "Role", "Participant")
in
#"Pivoted Column"Thank you, Vijay. Where does this code go?
Actually, what I get when I use that in PowerQuery is this:
Is there a way to fill in the names into the appropriate roles?
Thank you
Use this please
let Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content], #"Pivoted Column" = Table.Pivot(Source, List.Distinct(Source[Role]), "Role", "Participant"), Custom1 = Table.TransformColumnNames(#"Pivoted Column", each Text.Proper(_)) in Custom1Very nice!! Now I need to dissect your code and understand it .... but it works!
