If the data is always in groups of 3 lines as posted,
then you could easily draw it out this way

Assume data in A2:B2 down
In C2: =OFFSET($A$2,ROWS($1:1)*3-3,)
In D2: =OFFSET($B$2,ROWS($1:1)*3-3+COLUMNS($A:A)-1,)
Copy D2 to F2. Select C2:F2, fill down as far as required to exhaust the
data, until zeros are returned. Cols C to F returns the desired results.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:22,500 Files:370 Subscribers:66
xdemechanik
---
"Michael" wrote:
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