You'll need to explain the rules a little better....

You want to convert 992 vertical cells
into one row
.....but Excel 2003 only has 256 columns.

***********
Regards,
Ron

XL2002, WinXP


"cfman" wrote:

Hi all,

Is there a way to rotate a column of data into a row of data, in Excell
2003?

Let's say B8 - B1000, there are so many of them... I want to rotate it into
a row form...

Thanks a lot!