Hi,
I am trying to un-pivot this table-
<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 un-pivot this table-
A1 | A1 | A1 | A2 | A2 | A2 | |||
STORE RECEIPT WEEK | Floorset | Target | Instore | Newness | Target | Instore | Newness | |
FY20 | 100 | 89 | 25 | 200 | 193 | 55 |
<tbody>
</tbody>
To look like this-
Business | STORE RECEIPT WEEK | 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!