My original question came out broken up so..---the data i have takes up
800-900 columns BUT only 22 rows. the data needs to be set up like this to
be imported to a program called primer. to transpose this data, the program
does not like it. any suggestions?

"Ken Wright" wrote:

Can you transpose your data set, or do you already have more than 256 rows
of data as well.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------Â*------------------------------Â*----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------Â*------------------------------Â*----------------


"mybicycleisgreat" wrote in
message ...
I have a large data set the needs about 800-900 columns in a worksheet. I
limit for columns in excel is a about 200-300. i dont need any more rows
added, just columns.