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 updating this file so that dates in the header change and I dont want it to mess the query.
| Alternate Format Name | Availability % 15 Jan 2023 - 21 Jan 2023 | Availability % 22 Jan 2023 - 28 Jan 2023 | Availability % 29 Jan 2023 - 4 Feb 2023 |
| Adam | 0.00% | 0.00% | 0.00% |
| Shady | 0.00% | 0.00% | 0.00% |
| Ralf | 0.00% | 0.00% | 0.00% |
| Will | 0.00% | 0.00% | 0.00% |
| Sharon | 0.00% | 0.00% | 0.00%
|
Optimal result:
| Alternate Format Name | Time period | AVAILABILITY |
| Adam | Availability % 15 Jan 2023 - 21 Jan 2023 | 0.00% |
| Adam | Availability % 22 Jan 2023 - 28 Jan 2023 | 0.00% |
| Adam | Availability % 29 Jan 2023 - 4 Feb 2023 | 0.00% |
| Shady | Availability % 15 Jan 2023 - 21 Jan 2024 | 0.00% |
| Shady | Availability % 22 Jan 2023 - 28 Jan 2024 | 0.00% |
| Shady | Availability % 29 Jan 2023 - 4 Feb 2024 | 0.00% |
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
1 Reply
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