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".
on transform data, try to use "Unpivot other column", then select only Name