converting downloaded data from columns to rows

**newdude** · 10-02-2007, 08:07 AM

Ok, Here is a new task I am about to undertake. I am downloading data and some of it I want to change from being in a column to being in a row on another sheet. That is, i have numbers in column A and column C. I want to put this data in row 1 and 2 of sheet2. I will begin working on it but will be pleased with any help I can get.

**oldchippy** · 10-02-2007, 08:10 AM

You can use Copy > Paste Special > Transpose to convert from columns to rows or visa versa

**newdude** · 10-02-2007, 08:13 AM

oops that was easier then i thought just use transpose under paste. thanks anyway.

**oldchippy** · 10-02-2007, 08:16 AM

Glad to help - thanks for the feedback

**rr1050** · 01-07-2009, 05:50 AM

Is it possible to change a column to Row with reference using excel function.

**royUK** · 01-07-2009, 05:52 AM

rr1050

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread.