Paste Special / transpose

G

Guest

Excel 2003: I have a spreadsheet of 275 rows and columns to FQ.
Column A is all headings.
I want to transpose the entire spreadsheet, so I can then import it into
Access - that is with column headings as columns.
When I copy, go to another worksheet, right click in A1, and select Paste
Special / Transpose, I get the message that the copied data won't fit.
I have done this before successfully, but now - no joy.
I even made sure the row heights were the same!
Any ideas?
Thanks!
 
G

Guest

Since Excel has only 256 columns, you won't be able to transpose 275 rows.

You can transpose half into one worksheet, half into another, then combine
the tow in Access.
 
G

Guest

Of course.
I have my dumb hat on.
Thank you.

Duke Carey said:
Since Excel has only 256 columns, you won't be able to transpose 275 rows.

You can transpose half into one worksheet, half into another, then combine
the tow in Access.
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Transpose with linked data 6
"Paste Special / Transpose" problem 3
Transpose, Paste Special 2
Past Special- Transpose Function? 7
How to transpose data (Row to column) without losing the cell link 3
Transpose large column 3
paste special transpose problem 2
how paste transpose reverse? 2

Top