If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
moving alternating rows to a column with the order staying the sam
one way
In B1 place the formula =IF(MOD(ROW(),2)=1,A2,"") Copy it all the way to the bottom - you should get alternating rows where the switch # lines up next to the correct address# If so, copy the entire column B, the EditPaste Special Values If you need to keep all of these in the original order, insert a helper column & fill it with a series of ascending numbers. Then sort the entire bit on column B & delete all the rows where column B = "" If needed, resort on the helper column to return the list to the original order "ad" wrote: I am working on a sheet that has more 11000+ rows. I need to move alternating rows to a column without having to do it manually. However, currently A1 correspondes with A2, A3 with A4, etc. How can I move it from: address1 switch#1 address2 switch#2 to: address 1 switch#1 address 2 switch#2 address 3 switch#3 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How do I sort by row instead of by column? | PercivalMound | Worksheet Functions | 7 | August 28th, 2006 10:41 PM |
Moving Column Sums to Rows | Roger PB | General Discussion | 6 | March 26th, 2005 03:09 PM |
Formula to compare multiple rows values based on another column? | Murph | Worksheet Functions | 4 | February 21st, 2005 02:44 AM |
unable to repair inobox | Sudheer Mumbai | General Discussion | 1 | February 20th, 2005 11:55 AM |
Deleting rows contains certain text in column A | plumstone | General Discussion | 1 | September 17th, 2004 08:05 PM |