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

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

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