A quick answer based on the data is to copy the 2nd column and
pastespecial - Transpose. Since your 1st column has only 1 unique value
that will work without the need of a macro.

--
Tim Zych
www.higherdata.com
Compare data in worksheets and find differences with Workbook Compare
A free, powerful, flexible Excel utility


"RobM" wrote in message
...
Any idea's as to take data that looks like this:

1st column 2nd column
10075 6L
10075 6M
10075 6O

And make it look like this:

1st column 2nd column 3rd column 4th column
10075 6L 6M 6N