I have blocks of data that are all in colomn A and the blocks are 27 rows in
length. I want to transpose this data into a database format. I've written
the formula to do 1 line but I need to be able to copy this formula down so
that it moves on 27 rows instead of the 1 that it normally does when you copy
down formula. There is over 1000 blocks of data to transpose. I'm using the
2000 version.