Transpose data once cell at a time

**willy91785** · 12-20-2010, 10:39 AM

I'm working with Excel 2003 and running into what seems to be a memory problem as I try to transpose a large data range. After performing the Transpose function properly, Excel shuts down and tries to recover the document. I've tried transposing row by row with the same result.

What is some VB code that can perform the transpose function on one cell, possibly paste special - values that result, and then go to the next cell? Or is there a better way?

Small dummy data sheet provided but the actual range is A1:IK14 in reality.

**TMS** · 12-20-2010, 11:02 AM

I think the better way is to find out what's wrong with your data and/or your computer ;-)

I've just extended the small sample across the rows and copied it and transposed it with no issue ... which there shouldn't be.

Maybe you should try copying the data to a new workbook initially and then transposing it (as an experiment)

Regards

**willy91785** · 12-20-2010, 11:07 AM

Yes, I tried copying the rows over in the dummy sheet and that works for me as well. I've tried copying in a new workbook with no luck though. The issue is that the values in each cell are more than just one letter or number. Some cells contain hundreds of words. (The file is an export from a survey I run). This is why I am thinking it is a memory issue or something.

**watersev** · 12-20-2010, 11:10 AM

Your problem is not with transpose function itself. Try to restart your Excel or if no result your PC and try again.

**BigDat6CC** · 12-20-2010, 11:11 AM

What do the cells in your spreadsheet contain? Dates, numbers, bits of text, long strings of text?

**willy91785** · 12-20-2010, 11:13 AM

All of the above, David. Some of the cells contain long strings of text though.

**willy91785** · 12-20-2010, 11:18 AM

Originally Posted by watersev

Your problem is not with transpose function itself. Try to restart your Excel or if no result your PC and try again.

I've tried that. Maybe Excel needs to be uninstalled/reinstalled.

**BigDat6CC** · 12-21-2010, 10:27 AM

Willy

Sounds to me like a resource issue. Can you try the same thing on another PC that is a lot more powerful than the one you are using at the moment?