Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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.
Solved! Go to 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
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
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.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
137 | |
70 | |
64 | |
52 | |
50 |
User | Count |
---|---|
208 | |
91 | |
62 | |
59 | |
56 |