Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers!
Enter the sweepstakes now!Prepping for a Fabric certification exam? Join us for a live prep session with exam experts to learn how to pass the exam. Register now.
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% |
Solved! Go to Solution.
@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
User | Count |
---|---|
77 | |
70 | |
68 | |
53 | |
48 |
User | Count |
---|---|
45 | |
38 | |
35 | |
31 | |
28 |