Hi,
I am trying to change the format of this table (un-pivot)-
<tbody>
</tbody>
To look like this-
<tbody>
</tbody>
Could someone help me with the VBA code for this please?
Thanks in advance!
I am trying to change the format of this table (un-pivot)-
A1 | A1 | A1 | A2 | A2 | A2 | |||
YEAR | Floorset | Target | Instore | Newness | Target | Instore | Newness | |
FY20 | 100 | 89 | 25 | 200 | 193 | 55 |
<tbody>
</tbody>
To look like this-
Business | YEAR | Floorset | Target | Instore | Newness |
A1 | FY20 | 100 | 89 | 25 | |
A2 | FY20 | 200 | 193 | 55 |
<tbody>
</tbody>
Could someone help me with the VBA code for this please?
Thanks in advance!