I currently have a three columns of data which I need to convert to a different layout using VBA.
I need to go from this:
<tbody>
Tag
Drawing
Drawing Type
1
I1
IFC
1
I2
IFC
1
R1
Redline
1
B1
Bootleg
2
I3
IFC
2
R2
Redline
2
B2
Bootleg
3
I4
IFC
4
R3...