Use loop to re-arrange:
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 |
All times are GMT +1. The time now is 11:44 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com