Forum Discussion

SimonFA's avatar
SimonFA
Copper Contributor
Nov 27, 2019

Power Query: Help transposing/pivoting data set to correct records

I have a dataset that looks like this: record Code Value 1 v1 S 1 v2 23 1 v3 Power 2 v1 P 2 v2 25 2 v3 Power 2 v4 23/12/2018 3 v1 S 3 v3 Gas 3 v...
BI & Data Analysis
excel
power bi
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Nov 27, 2019

SimonFA 

With pivoting that will be done by default, generated script is

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Changed Type" = Table.TransformColumnTypes(
        Source,
        {
            {"record", Int64.Type},
            {"Code", type text},
            {"Value", type any}
        }
    ),
    #"Pivoted Column" = Table.Pivot(
        #"Changed Type",
        List.Distinct(#"Changed Type"[Code]),
        "Code",
        "Value")
in
    #"Pivoted Column"

for

Resources