Urgent!

A

adubey

How do I invert a large set of tabled data in Excel? I want to chang
the rows to columns and vice versa. I have tried using "Pivot Table
and it does not work...I tried to use "Transpose"...does not work.
have about 6000 rows and so Excel can't handle this many rows! I a
looking for the easiest/quickest way to do this. Please help ASAP
 
K

Ken Wright

OK, so as you have just said, Excel doesn't have that many columns, so what
exactly are you looking for us to do. If you want a means of getting 6000
columns then it can't be done, or if it is something else you are looking for
then you may need to clarify.
 
J

JE McGimpsey

XL doesn't have 6000 columns. Check out Quattro Pro which can have up to
18,000 columns.
 
A

Alan Beban

You can "transpose" the data into a VBA array. Is that of any interest
to you?

Alan Beban
 
Top