Forum Discussion

JamesMidgley's avatar
JamesMidgley
Icon for Advocate I rankAdvocate I
9 years ago
Solved

create new table by creating new columns based upon values in existing column

I need to be able to convert two existing columns and create a new table.     Any guidance greatly appreciated
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    9 years ago

    Hi,

     

    The following M code will solve the problem

     

    let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Mode", type text}, {"Outcome", type text}}),
    #"Duplicated Column" = Table.DuplicateColumn(#"Changed Type", "Outcome", "Outcome - Copy"),
    #"Pivoted Column" = Table.Pivot(#"Duplicated Column", List.Distinct(#"Duplicated Column"[#"Outcome - Copy"]), "Outcome - Copy", "Outcome")
in
    #"Pivoted Column"

    Hope this helps.

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
9 years ago

Hi,

 

The following M code will solve the problem

 

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Mode", type text}, {"Outcome", type text}}),
    #"Duplicated Column" = Table.DuplicateColumn(#"Changed Type", "Outcome", "Outcome - Copy"),
    #"Pivoted Column" = Table.Pivot(#"Duplicated Column", List.Distinct(#"Duplicated Column"[#"Outcome - Copy"]), "Outcome - Copy", "Outcome")
in
    #"Pivoted Column"

Hope this helps.