Hi all,

I have a something that I would have thought Excel could handle but have no
idea how to actually do it.

I have an excel sheet with 20,000 rows which is populated with a unique ID
number and a phone number however rather than each phone number being placed
on the same line that corresponds with each phone number it has been placed
on the next line down ie

Unique ID Phone Number
123 0161 555 2269
123 0161 555 1234
123

and I need it to be

Unique ID Phone Number
123 0161 555 2269 0161 555 1234

thanks in advance

Michael