Urgent!

  • Thread starter Thread starter adubey
  • Start date Start date
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
 
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.
 
XL doesn't have 6000 columns. Check out Quattro Pro which can have up to
18,000 columns.
 
You can "transpose" the data into a VBA array. Is that of any interest
to you?

Alan Beban
 
Back
Top