Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
I have a folder with a growing number of files. How can I transpose each file, then combine them? Thanks!
File 1:
Date | 1/1/2023 | 1/2/2023 |
Amount | $50 | $60 |
File 2:
Date | 1/3/2023 | 1/4/2023 |
Amount | $70 | $80 |
Desired end result:
Date | Amount |
1/1/2023 | $50 |
1/2/2023 | $60 |
1/3/2023 | $70 |
1/4/2023 | $80 |
Solved! Go to Solution.
Table.Combine(List.Transform(Folder.Files("your folder")[Content],each Table.PromoteHeaders(Table.Transpose(Excel.Workbook(_)[Data]{0}))))
Table.Combine(List.Transform(Folder.Files("your folder")[Content],each Table.PromoteHeaders(Table.Transpose(Excel.Workbook(_)[Data]{0}))))
Use the Combine & Transform feature and in the transform sample query select your non-date column(s), right click and choose "Unpivot other columns".
Pat
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 |
---|---|
15 | |
15 | |
13 | |
12 | |
11 |