Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Transform rows from certain columns to colunms

Hello all,   I have a very simple question. I have a very long table with many repatitive question. Here is an example:   I would like to tranform this table so as every question be under a...
Need Help
Floriankx's avatar
Floriankx
Icon for Solution Sage rankSolution Sage
8 years ago

Hello,

 

In Power Query it is

let
    Source = Excel.CurrentWorkbook(){[Name="Questions"]}[Content],
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Reference", Int64.Type}, {"Question", type text}, {"Answer", type text}}),
    #"Pivoted Column" = Table.Pivot(#"Changed Type", List.Distinct(#"Changed Type"[Question]), "Question", "Answer")
in
    #"Pivoted Column"