how much data you can transpose?

[Lynn Bales]

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!

[Alex Delamain]

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

[Lynn Bales]

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
>
>

[Bob Phillips]

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" <[email protected]> wrote in message
news:[email protected]...
> 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
> >
> >