Loop thru column and transpose data

[sandy armstrong]

I have data in column A and i would like to copy 9 rows in that column then transpose the data in column I-R and and contunie to the next 9 rows and transpone again until it reaches the last row in column A. Then once the last part is reached delete column A AND B. I tryed to record a macro to do this but it wont loop on its own and keep going it stops after the first one the i have to press short cut key to move to the next one doing it like that could take a really long time

Thanks to any one who can help...
And Happy Thanksgiving Everyone!!!!