Use loop to re-arrange:

A

Ardy

Hello All:
I really am getting stock on this. Can somebody start me and I try to
fine tune it. I have two column ("A:B") worth of survey points. Each
5 row (1,2,3,4,5) makes a cross section, I need start with row 2 -
"2A" and "2B" and move it to "1C" and "1D " then "3A" and "3B" move it
to "1E" and "1F" then "4A" and "4B" move it to "1G" and "1H" then "5A"
and "5B" move it to "1I" and "1J".

This completes one set of data that will give one cross section. I
need to do this loop until it hits an empty cell.

Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top