I would like to repeat a macro until no data is found.

I am pulling data from a column and transposing the data into rows. The
data repeats after ten rows and than I have to start a new row to transpose.
I have created a macro that transposes the data, but I want to repeat the
macro until no other data is found. Any advice would be appreciated.