Unpivoting to more than one column

[Alirezam]

Hi guys,

Might be rather a simple question but your help is much appreciated,

I do not know how to unpivot table with many columns to a table with 2 columns. As far as I know if you hold the "date" and "time" and unpivot the rest, you only get 1 column, not 2 columns.

Suppose that I have a table below and I want to get the second table (black font). Excel file attached. 

What I haveWhat I want

[v-xuding-msft]

Hi @Alirezam ,

Could you tell me if your problem has been solved? If it is, kindly mark the helpful answer as a solution if you feel that makes sense. Welcome to share your own solution. More people will benefit from here.

Best Regards,

Xue Ding

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[parry2k]

@Alirezam you select date and time column and right click and select unpivot other columns. That will do it.

Here is sample query which you can test

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMjIwtNA1MAQiJR0lQyMrAwMgbQLEpkBsDMTmSrE6SMqMQMIQVWZQFaZgHSiqQMImEFUWUGyGaRbYGoSNIBdYgunYWAA=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [Date = _t, Time = _t, #"A-X" = _t, #"A-Y" = _t, #"B-X" = _t, #"B-Y" = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Date", type date}, {"Time", type time}, {"A-X", Int64.Type}, {"A-Y", Int64.Type}, {"B-X", Int64.Type}, {"B-Y", Int64.Type}}),
    #"Unpivoted Other Columns" = Table.UnpivotOtherColumns(#"Changed Type", {"Date", "Time"}, "Attribute", "Value")
in
    #"Unpivoted Other Columns"

[Alirezam]

Hi, as I already mentioned in my inquiry, this way (as you replied) just come up with 1 column. I want 2 columns!

[parry2k]

@Alirezam did you tested the code I gave to you. Can you share screen shot? Read this post to get your answer quickly.

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490