Transposing data
 

Is there a limit to how much data you can transpose? I am in a worksheet with
52 columns and 525 rows and it won't work. I get the error that the column
width doesn't match. It will work if I do it piecemeal. Is there a way around
this issue?

Thanks!

The problem is that excel only has 255 columns so you cannot transpose a
table with 525 rows.


--
Alex Delamain
------------------------------------------------------------------------
Alex Delamain's Profile: http://www.excelforum.com/member.php...o&userid=11273
View this thread: http://www.excelforum.com/showthread...hreadid=394218

And is there anyway around this?

"Alex Delamain" wrote:


The problem is that excel only has 255 columns so you cannot transpose a
table with 525 rows.


--
Alex Delamain
------------------------------------------------------------------------
Alex Delamain's Profile: http://www.excelforum.com/member.php...o&userid=11273
View this thread: http://www.excelforum.com/showthread...hreadid=394218

Transpose 52 by the first 256 rows to one place, 52 by the next 256 to
another, then the final 52 by 13.

--
HTH

Bob Phillips

"Lynn Bales" wrote in message
...
And is there anyway around this?

"Alex Delamain" wrote:


The problem is that excel only has 255 columns so you cannot transpose a
table with 525 rows.


--
Alex Delamain
------------------------------------------------------------------------
Alex Delamain's Profile:
http://www.excelforum.com/member.php...o&userid=11273
View this thread:
http://www.excelforum.com/showthread...hreadid=394218