Transposing data

[Guest]

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.

 

[Guest]

And is there anyway around this?

 

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