Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Splitting interleaved column into multiple columns

Hello everyone, I have been using Power Query for a few months now and I have a question for a data clean-up problem that comes up quite often. I am wondering whether there is something in-built in P...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Try Unpiviot

 

It results in the Unpivoted columns step below. 

 

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("JYvJDQAgDMN2ybsPWo7CLFX3X4MGPpFjyREwhcBajR6kBHSTnbO+mOTB6V8YmZ22J04hK39vFTEZyLw=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [A = _t, B = _t, C = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"A", Int64.Type}, {"B", Int64.Type}, {"C", Int64.Type}}),
    #"Unpivoted Columns" = Table.UnpivotOtherColumns(#"Changed Type", {}, "Attribute", "Value")
in
    #"Unpivoted Columns"

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Thanks but this is not correct and is the opposite of what I wanted.