MetaChat - How do I get a loooong row in excel to become a looong column?

MetaChat is an informal place for MeFites to touch base and post, discuss and chatter about topics that may not belong on MetaFilter. Questions? Check the FAQ. Please note: This is important.

11 March 2008

How do I get a loooong row in excel to become a looong column? Mac OSX excel; this means that paste special -> transpose doesn't work.→[More:]

Do you know that I haven't brushed my hair in a month (whee depression) and i will need to cut it all off. Plus I can barely get myeslef to care about this excel problem even though it's urgent.

AI try to open the file and do the cut paste special transpose but that's ms office 08 (on the pc) and that paste special, as well as paste, is greyed out.

post by: By the Grace of God at: 08:42 | 12 comments

I think I mitenmake this a job on jobs-filter. But know that I will pay for solutions to this.

posted by By the Grace of God 11 March | 08:52

Try copying rather than cutting. On the PC, it won't work if I try to cut.

posted by mullacc 11 March | 08:53

Neither copy nor cut are working.

If you're interested in helping me fix this, name a rate - I can paypal. (Offer not valid if mods here would preer not such things.

posted by By the Grace of God 11 March | 08:57

Hrm, that was my big idea.

Are these values or formulas you're trying to paste? Maybe try paste-special->values, then transpose the values instead?

Have you tried the transpose() funciton?

posted by mullacc 11 March | 09:01

You could email it to someone on a Windows machine, have them cut->transpose and then email it back? My email is my username at gmail if you want to try that.

Alternately, try saving as a .csv (assuming it's just values you need to transpose, and only one column.) Then replace the line breaks with commas in a text editor, and then import back in.

posted by karmakaze 11 March | 09:50

I just tried it in Excel 2004 for Mac, with the added trick of going to a brand new workbook (or worksheet) before doing the Paste Special, and the Transpose option was there, and it seemed to work.

In other words:

1. Select the entire row with the data you want to transpose.
2. Do Edit > Copy.
3. Go to a new workbook or worksheet.
4. Select an entire column.
5. Go to Edit > Paste Special...
6. Choose the Transpose option and hit OK.

posted by chrismear 11 March | 09:56

Is there any way I can make that transpose option appear in excel 2008? This here http://discussions.apple.com/thread.jspa?messageID=6792976 seems to say its not available.

posted by By the Grace of God 11 March | 10:08

Sent to you, karmakaze..

posted by By the Grace of God 11 March | 10:43

Of course, I misread that a bit. For the brute force csv option of a column to a row, it would be a matter of making the commas into line breaks...

posted by karmakaze 11 March | 10:50

ugh, sent karmakaze the wrong file.

posted by By the Grace of God 11 March | 11:40

Well, I'm still here if you need to try again.

posted by karmakaze 11 March | 12:44

re-sent.. many thanx.

posted by By the Grace of God 11 March | 13:47

← OK we need a new word. . .. || This is the lost nuggets of culture thread. →

HOME || REGISTER || LOGIN