Column headers to be in rows

[sabry_303]

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%

[Arul · Accepted solution]

@sabry_303 ,

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