Transposing rows of data into columns of data

Hi,

I am trying to get large date into a specific format.

I have attached the example..

Sample23.xlsx

I have delimited the numbers to columns making a large number of columns.. I have over 3500 numbers in one cell.

Is there a easy way out? I am noob to excel and not sure how it will work out.

thanks a bunch.. it solved the problem

There is a formula-based solution to a similar problem in post #7 of this thread:

http://www.excelforum.com/excel-gene...html?p=2951411

Hope this helps.

Pete