software

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?

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,quot;keepquot;,quot;deletequot;)

Then this in E1:
=IF($D1=quot;keepquot;,A2,quot;quot;)

And this in F1:
=IF($D1=quot;keepquot;,B2,quot;quot;)

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 quot;deletequot;
Delete those visible rows
data|Filter|autofilter (to remove the filter)GreenPower wrote:
gt;
gt; I have a worksheet like this:
gt; (row 1 ) custome_name account_no time_on
gt; (row 2) time_off phone_no
gt;
gt; there are several hundred of additional rows following . I need to combine
gt; each set of 2 rows into 1 row/record to be sorted.
gt;
gt; what I want:
gt; (row 1) custome_name account_no time_on time_off
gt; phone_no
gt;
gt; Can anyone help?

--

Dave Peterson