Transposing data

  • Thread starter Thread starter Guest
  • Start date Start date
G

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!
 
The problem is that excel only has 255 columns so you cannot transpose a
table with 525 rows.
 
Transpose 52 by the first 256 rows to one place, 52 by the next 256 to
another, then the final 52 by 13.
 
Back
Top