anglais428
Well-known Member
- Joined
- Nov 23, 2009
- Messages
- 634
- Office Version
- 2016
- Platform
- Windows
Hello,
I would like to transpose the first table into the second table. The table will always begin in Cell A1 but could have varying row and column lengths. I have been toying with VBA but cannot find an appropriate solution.
Table 1 (original)
<tbody>
</tbody>
Table 2 (desired output)
<tbody>
</tbody>
Thanks.
I would like to transpose the first table into the second table. The table will always begin in Cell A1 but could have varying row and column lengths. I have been toying with VBA but cannot find an appropriate solution.
Table 1 (original)
TEST | LOCATION | 2016A | 2016B | 2016C | 2017A | 2017B | 2017C | 2018A | 2018B | 2018C |
1 | UK | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 |
2 | USA | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 |
<tbody>
</tbody>
Table 2 (desired output)
TEST | LOCATION | A | B | C | Year |
1 | UK | 5 | 6 | 7 | 2016 |
1 | UK | 8 | 9 | 10 | 2017 |
1 | UK | 11 | 12 | 13 | 2018 |
2 | USA | 20 | 21 | 22 | 2016 |
2 | USA | 23 | 24 | 25 | 2017 |
2 | USA | 26 | 27 | 28 | 2017 |
<tbody>
</tbody>
Thanks.