Hi there,
I have a sheet in the following format
<tbody>
</tbody>
which I want to convert into the below format.
<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
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>
Can any one please help?
Cheers