Forum Discussion
Column headers to be in rows
Hi Experts, I have the below table for employee availability, and I would like to have the time in column headers to be in the rows so that Adam has 3 rows for the the 3 periods. Also, I will be...
Anonymous ,
1. Go to Power query editor and select these 3 columns in the your table.
2. Right click on any of the selected columns and do unpivot columns.
3. You will get the desired result.
Thanks,
Arul
Anonymous ,
1. Go to Power query editor and select these 3 columns in the your table.
2. Right click on any of the selected columns and do unpivot columns.
3. You will get the desired result.
Thanks,
Arul