Thx @JeffreyBrown & @NoSparks for the replies - I finally had time to get back on this and tested Jeff's. It provided unexpected results - here's why.. (and more info that should help clarify)..



Data pattern is repetitive all the way down column A. (it's only column w/ data)

A1:A6 is populated, the following 2 rows are blank, pattern repeats A9:A14 is populated, 2 blanks follow, A17:A22 populated...etc

Needed to select A1:A6 and paste it adjacently TRANSPOSEd (B1:G1)
with the intent to delete those (now) un-needed rows 2 through 6 plus blank rows found between each dataset




A9:A14 paste it adjacently (B9:G9)
then delete the un-needed rows 10 through 16



A17:A22 paste it adjacently (B17:G17)
then delete the un-needed rows 18 through 24


The sample code I posted was pasting into B6 which was not wanted..
Definitely needed to be pasted along the top row of existing data...
(if it starts on A9 then yes, paste should also start on row 9 in Col B to right)

Thanks for asking for that clarification NoSparks - I think the above expanded info is more clear on the intent and hope that helps with what solution might be available..