combine 2 rows into 1 record
 

I have a worksheet like this:
(row 1 ) custome_name account_no time_on
(row 2) time_off phone_no

there are several hundred of additional rows following . I need to combine
each set of 2 rows into 1 row/record to be sorted.

what I want:
(row 1) custome_name account_no time_on time_off
phone_no

Can anyone help?

combine 2 rows into 1 record
 

So odd number rows have columns A:C populated and even numbered rows have
columns A:B populated??

If yes, I'd put this in D1:
=IF(MOD(ROW(),2)=1,"keep","delete")

Then this in E1:
=IF($D1="keep",A2,"")

And this in F1:
=IF($D1="keep",B2,"")

Now drag these three formula cells down the columns.

Select D:F
Edit|copy
Edit|paste special|values

Select column D
data|filter|autofilter
filter to show "delete"
Delete those visible rows
data|Filter|autofilter (to remove the filter)


GreenPower wrote:

I have a worksheet like this:
(row 1 ) custome_name account_no time_on
(row 2) time_off phone_no

there are several hundred of additional rows following . I need to combine
each set of 2 rows into 1 row/record to be sorted.

what I want:
(row 1) custome_name account_no time_on time_off
phone_no

Can anyone help?

--

Dave Peterson