Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

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 ...
Need Help
  • bolfri's avatar
    bolfri
    3 years ago

    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 NameMonthValue
    Apple Project Inc.June 202356.5
    Apple Project Inc.September 202332.4
    Apple Project Inc.February 202418.7
    Banana Project Ltd.June 202312.1
    Banana Project Ltd.September 20239.7
    Banana Project Ltd.February 202430.0
bolfri's avatar
bolfri
Solution Sage
3 years ago

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 NameMonthValue
Apple Project Inc.June 202356.5
Apple Project Inc.September 202332.4
Apple Project Inc.February 202418.7
Banana Project Ltd.June 202312.1
Banana Project Ltd.September 20239.7
Banana Project Ltd.February 202430.0