Transpose every 2 columns into new row, moving to new row after last column

[prshntmv]

Hi there,
I have a sheet in the following format[TABLE="width: 500"]
<tbody>[TR]
[TD]Date[/TD]
[TD]Key1[/TD]
[TD]Attr1[/TD]
[TD]Key2[/TD]
[TD]Attr2[/TD]
[TD]Key3[/TD]
[TD]Attr3[/TD]
[TD]Key4[/TD]
[TD]Attr4[/TD]
[/TR]
[TR]
[TD]1 Jan 2019[/TD]
[TD]1[/TD]
[TD]23[/TD]
[TD]3[/TD]
[TD]43[/TD]
[TD]3[/TD]
[TD]25[/TD]
[TD]1[/TD]
[TD]54[/TD]
[/TR]
[TR]
[TD]2 Jan 2019[/TD]
[TD]2[/TD]
[TD]23[/TD]
[TD]2[/TD]
[TD]23[/TD]
[TD]2[/TD]
[TD]54[/TD]
[TD]2[/TD]
[TD]23[/TD]
[/TR]
[TR]
[TD]3 Jan 2019[/TD]
[TD]4[/TD]
[TD]25[/TD]
[TD]1[/TD]
[TD]54[/TD]
[TD]4[/TD]
[TD]43[/TD]
[TD]2[/TD]
[TD]34[/TD]
[/TR]
[TR]
[TD]4 Jan 2019[/TD]
[TD]3[/TD]
[TD]23[/TD]
[TD]4[/TD]
[TD]23[/TD]
[TD]2[/TD]
[TD]32[/TD]
[TD]4[/TD]
[TD]23[/TD]
[/TR]
[TR]
[TD]5 Jan 2019[/TD]
[TD]1[/TD]
[TD]27[/TD]
[TD]1[/TD]
[TD]24[/TD]
[TD]1[/TD]
[TD]14[/TD]
[TD]2[/TD]
[TD]44[/TD]
[/TR]
</tbody>[/TABLE]

which I want to convert into the below format.

[TABLE="width: 500"]
<tbody>[TR]
[TD]Date[/TD]
[TD]Key[/TD]
[TD]Attr[/TD]
[/TR]
[TR]
[TD]1 Jan 2019[/TD]
[TD]1[/TD]
[TD]23[/TD]
[/TR]
[TR]
[TD]1 Jan 2019[/TD]
[TD]3[/TD]
[TD]43[/TD]
[/TR]
[TR]
[TD]1 Jan 2019[/TD]
[TD]2[/TD]
[TD]25[/TD]
[/TR]
[TR]
[TD]1 Jan 2019[/TD]
[TD]1[/TD]
[TD]54[/TD]
[/TR]
[TR]
[TD]2 Jan 2019[/TD]
[TD]2[/TD]
[TD]23[/TD]
[/TR]
[TR]
[TD]2 Jan 2019[/TD]
[TD]2[/TD]
[TD]23[/TD]
[/TR]
[TR]
[TD]2 Jan 2019[/TD]
[TD]2[/TD]
[TD]54[/TD]
[/TR]
[TR]
[TD]2 Jan 2019[/TD]
[TD]2[/TD]
[TD]23[/TD]
[/TR]
</tbody>[/TABLE]
And so on. This is essentially transposing every 2 columns (starting from Key1) into rows, until the last set of columns and then starting again with second row of Key1 column and so on.

Can any one please help?

Cheers

 

[sandy666]

With PowerQuery (Get&Transform) try UnPivot Selected Columns for Keys then the same for Attr

 

[prshntmv]

With PowerQuery (Get&Transform) try UnPivot Selected Columns for Keys then the same for Attr

Thanks. Is it not possible without using Powerquery? as in., using inbuilt excel functions?

 

[sandy666]

I don't know, maybe someone else will give you formula(s) solution

Have a nice day