Dynamic Transformation of Column Values to Column Names

[gunasai]

Hi everyone,

I had the following problem

Considering I have the following table,

Ord_num	Cust_name	Dates	Date Values
1111	ABC	Order Date	05/01/2021
1111	ABC	Shipped Date	05/03/2021
1111	ABC	Delivered Date	05/05/2021

I wanted the following table from the above table,

Ord_num	Cust_name	Order_date	Shipped_date	Delivered Date
1111	ABC	05/01/2021	05/03/2021	05/05/2021

How do I transform into this?

Any help would be appreciated.

Thanks in advance.

[v-deddai1-msft · Accepted solution]

Hi @gunasai ,

You can use IU to do it, select the last two columns and click pivot columns:

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

Best Regards,

Dedmon Dai

[Ashish_Mathur]

Hi,

This M code works

let
    Source = Excel.CurrentWorkbook(){[Name="Data"]}[Content],
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Ord_num", Int64.Type}, {"Cust_name", type text}, {"Dates", type text}, {"Date Values", type date}}),
    #"Pivoted Column" = Table.Pivot(#"Changed Type", List.Distinct(#"Changed Type"[Dates]), "Dates", "Date Values")
in
    #"Pivoted Column"

Hope this helps.