VBA code to format (un-pivot) table

[KK3008]

Hi,

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!