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

Date	Key1	Attr1	Key2	Attr2	Key3	Attr3	Key4	Attr4
1 Jan 2019	1	23	3	43	3	25	1	54
2 Jan 2019	2	23	2	23	2	54	2	23
3 Jan 2019	4	25	1	54	4	43	2	34
4 Jan 2019	3	23	4	23	2	32	4	23
5 Jan 2019	1	27	1	24	1	14	2	44

<tbody>
</tbody>

which I want to convert into the below format.

Date	Key	Attr
1 Jan 2019	1	23
1 Jan 2019	3	43
1 Jan 2019	2	25
1 Jan 2019	1	54
2 Jan 2019	2	23
2 Jan 2019	2	23
2 Jan 2019	2	54
2 Jan 2019	2	23

<tbody>
</tbody>

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