Forum Discussion

davidv64's avatar
davidv64
New Member
3 years ago
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...
Need Help
  • Vijay_A_Verma's avatar
    Vijay_A_Verma
    3 years ago

    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
Vijay_A_Verma's avatar
Vijay_A_Verma
Most Valuable Professional
3 years ago

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"
davidv64's avatar
davidv64
New Member
3 years ago

Thank you, Vijay. Where does this code go?