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

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
>