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>
TEST
LOCATION
2016A
2016B
2016C
2017A...