Hi VBA Expert,
Need your expertise in building a VBA to copy the data from Sheet 1 and transpose paste in Sheet 2 – As per the below format:
Sheet 1 (will have a pivot in the below format) - Data needs to be copied from this sheet:
<tbody>
A
B
C
D
ID
GBP
USD
Grand Total
12345
220675.50...