Hi,
Assuming that the data is already sorted
Name the headers below the data table ie in the blanks cells after the table
is over.
Unique id and phone numbers
Then under unique id you can put the number. Then select & copy the phone
numbers
then under the header phone number put the cursor on the cell and right
clickPaste specialcheck the transpose boxOk this will paste the data
and will give you the result as expressed by you in your example.
--
_______________________
Click "Yes" if it helps
________
Thanks
Suleman Peerzade


"Michael" wrote:

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