Forum Discussion
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 |
| Alex | Feb 2023 | xxx |
| Ben | Feb 2023 | xxx |
| Chris | Feb 2023 | xxx |
| Alex | Mar 2023 | xxx |
| Ben | Mar 2023 | xxx |
| Chris | Mar 2023 | xxx |
| Alex | Apr 2023 | xxx |
| Ben | Apr 2023 | xxx |
| Chris | Apr 2023 | xxx |
Before this, i use to copy paste manually and it took way too much time when we have way too much rows.
Thanks.
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".
4 Replies
on transform data, try to use "Unpivot other column", then select only Name
If this post helps, then please consider Accept it as the solution and kudos to help the other members find it more quickly.
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.
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".
