Forum Discussion

mouri_kimochi's avatar
mouri_kimochi
New Member
3 years ago
Solved

Convert rows to multiple column

Hi,   I need help to convert this table:   Name Feb 2023 Mar 2023 Apr 2023 Alex xxx xxx xxx Ben xxx xxx xxx Chris xxx xxx xxx   into this:   Name Month Sales ...
Need Help
Tips and Tricks
  • isha_dhameliya's avatar
    isha_dhameliya
    3 years ago

    for that you have to unpivot the table,

    select the "Feb 2023","Mar 2023","Apr 2023" columns and then select the option "unpivot only selected columns".

    OR

    select the "Name" column and then select the "unpivot other columns".

Mayuri_Ghosh's avatar
Mayuri_Ghosh
Icon for Helper I rankHelper I
3 years ago

Hi,

To convert this table you need to unpivot(turns column into rows) it from Power Query Editor. Select the columns and right click >Unpivot. 

Thank you.