Forum Discussion
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 ...
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".
If this post helps, then please consider Accept it as the solution and kudos to help the other members find it more quickly.