Forum Discussion
Transform Data on Columns with Changing Names
Hi there, I have an Excel spreadsheet which exports from another source. We will export the Excel file to the same location every time, then refresh the report. I need to Change the Type of some ...
Hi, just unpivot those columns to a single column and change the type.
https://learn.microsoft.com/en-us/powerquery-m/table-unpivotothercolumns
You will receive something like this:
Project Name Month Value Apple Project Inc. June 2023 56.5 Apple Project Inc. September 2023 32.4 Apple Project Inc. February 2024 18.7 Banana Project Ltd. June 2023 12.1 Banana Project Ltd. September 2023 9.7 Banana Project Ltd. February 2024 30.0
Bolfri,
Thank you so much!
An added layer of complexity is that there are multiple columns with the same name (July 2023 for example), but one of them contains values for hours, and the other contains values for dollars.
I am working with my team to export this information in a different way so we can leverage your solution.