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 Multiple Rows at one time
I have a worksheet that contains relevant data (I imported the data) in 2
rows; every 2 rows is a new incidence of data. Example: (row 1) Hold Flag (row 2) FIELD: YES/NO (Length=3) (row 3) Date (row 4) FIELD: DATE (Length=6) and so on. What I need, is for row 1 to be in column 1 and for row 2 to be in column 3 (same row) so that the data looks like this: Hold Flag empty cell FIELD: YES/NO (Length=3) Date empty cell FIELD: DATE (Length=6) Can anyone help me? Excel doesn't allow me to select and drag/drop multiple (every other) cells at a time. (As an added bonus, if you can tell me how to put the (length=x) into a 3rd column that would be great.!!) I have very limited knowledge of programming in Excel. This spreadsheet has over 5000 rows and I can't do this manually. Thanks Lynda |
#2
|
|||
|
|||
Put this in C1:
=if(mod(row(),2)=1,A2,"DELETE") And drag down column C. Select column C edit|copy, edit|paste special|values Filter by column C to show just the DELETES delete those visible rows. After I had the data in one row, then I'd use: edit|replace what: ( with: ,( replace all Then I could select column C and do data|text to columns delimited by comma And I think I'd be done. Lynda M wrote: I have a worksheet that contains relevant data (I imported the data) in 2 rows; every 2 rows is a new incidence of data. Example: (row 1) Hold Flag (row 2) FIELD: YES/NO (Length=3) (row 3) Date (row 4) FIELD: DATE (Length=6) and so on. What I need, is for row 1 to be in column 1 and for row 2 to be in column 3 (same row) so that the data looks like this: Hold Flag empty cell FIELD: YES/NO (Length=3) Date empty cell FIELD: DATE (Length=6) Can anyone help me? Excel doesn't allow me to select and drag/drop multiple (every other) cells at a time. (As an added bonus, if you can tell me how to put the (length=x) into a 3rd column that would be great.!!) I have very limited knowledge of programming in Excel. This spreadsheet has over 5000 rows and I can't do this manually. Thanks Lynda -- Dave Peterson |
#3
|
|||
|
|||
IT WORKED!!!! THANK YOU SOOOOOOO MUCH!!!
I am forever grateful!!! Lynda "Dave Peterson" wrote: Put this in C1: =if(mod(row(),2)=1,A2,"DELETE") And drag down column C. Select column C edit|copy, edit|paste special|values Filter by column C to show just the DELETES delete those visible rows. After I had the data in one row, then I'd use: edit|replace what: ( with: ,( replace all Then I could select column C and do data|text to columns delimited by comma And I think I'd be done. Lynda M wrote: I have a worksheet that contains relevant data (I imported the data) in 2 rows; every 2 rows is a new incidence of data. Example: (row 1) Hold Flag (row 2) FIELD: YES/NO (Length=3) (row 3) Date (row 4) FIELD: DATE (Length=6) and so on. What I need, is for row 1 to be in column 1 and for row 2 to be in column 3 (same row) so that the data looks like this: Hold Flag empty cell FIELD: YES/NO (Length=3) Date empty cell FIELD: DATE (Length=6) Can anyone help me? Excel doesn't allow me to select and drag/drop multiple (every other) cells at a time. (As an added bonus, if you can tell me how to put the (length=x) into a 3rd column that would be great.!!) I have very limited knowledge of programming in Excel. This spreadsheet has over 5000 rows and I can't do this manually. Thanks Lynda -- Dave Peterson |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Multiple rows within multiple rows | Ace9x | Using Forms | 3 | September 9th, 2005 10:04 PM |
How do I get multiple Excel rows merged into Word document when .. | sebmailmerge | Mailmerge | 2 | April 20th, 2005 03:47 PM |
How do I add multiple rows to a table? | Adding rows to tables | Tables | 3 | January 29th, 2005 08:26 PM |
Support for multiple time zones in Outlook and web mail. | Kevin | Calendar | 1 | December 15th, 2004 06:21 PM |
Outlook 2003 Terminal Server Time Zone issue | Robert Strom | Calendar | 2 | May 26th, 2004 10:50 PM |