View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
GreenPower
 
Posts: n/a
Default 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?