copy loop

[paulntee]

I need to copy a range of say 5 cells from A1:A5 to C1:C5 Then repeat for the next 5 rows, repeat for next 5, until no more data (actually I want to transpose the data from vert to horizontal, but I can do that part myself) I want to use a relative reference for this and am having trouble getting a loop to work and increment the positions correctly. Please help - it's my first time here. Thanks

 

[paulntee]

Those code items all worked.
The two from schielrn and ravishankar were most elegant and do exactly what I needed. Thanks so much.
One interesting thing was on the longer code set - it did work but took a lot longer to run for a big dataset - a tribute to keeping code streamlined!
I also tried the non code solution posted, but had trouble w that.

Thanks again for all contributions - I've got what I need.