Transpose Col T:W in a sheet with data in Column A: W

[ddander54]

My Data:

Row 1:2 are headers
Columns are A:W
Data starts in Column A:3, A:A is a unique number, never blanks or null

A...B...C...D...etc...T...U...V...W
1...d...t...d...etc...20...30...40...50
2...b...c...d...etc...33...56...78...90
3...e...f...g...etc...21...8...16...55
~200 rows

What I would like is for each row to transpose column T:W at the end of column S

Result:
A...B...C...D...etc...S...T
1...d...t...d...etc...g...20
1...d...t...d...etc...g...30
1...d...t...d...etc...g...40
1...d...t...d...etc...g...50
2...b...c...d...etc...y...33
2...b...c...d...etc...y...56
2...b...c...d...etc...y...78
2...b...c...d...etc...y...90
etc
Note: ... are just to hold the data in somewhat of a column

Initially I thought I could do it with a Pivot table, but that didn't work out (still learning pivot tables), so thought that VBA might be the best way to get the data how I need it, as I'll need to do this every day or so to a new file...

Thanks in advance for any help....
Don

 

[ddander54]

Perfect! Thanks for sticking with me to figure out the issue. I changed the 2 to 3 to fix my header issue, but otherwise it was perfect and only ran about.5 seconds rather than the 22-28 minutes it was taking! Thanks so much!

 

[Fluff]

Glad to help & thanks for the feedback