# Excel help

I know the answer to my question is probably in the 'help' pages of excel but I have been unable to find it.

I have a list of figures in vertical column and want to move the figures to a horizontal row.

o
o
o
o
o

to

ooooo

Is there a quick way of doing this?

It is actually for a friend - but I want to know too.

Thanks
20:43 Mon 01st Oct 2012

1 to 9 of 9

 this might help http://www.howtogeek....n-excel-the-easy-way/ 20:44 Mon 01st Oct 2012 Go a Google search for Excel paste special transpose 20:44 Mon 01st Oct 2012 use the mouse to paste and one of the ways offered is transpose which does exactly what you want 20:45 Mon 01st Oct 2012 Question Author Thanks guys - brilliant. Will pass this information on and take all the credit for it. :-) 21:04 Mon 01st Oct 2012 oh nuts! wolf - you lovely lady, just goi in from work .. logged on and saw this post in the listings. i thought wolf63 wants my help, i'd better see what i can do oh well -- ego deflated now. 22:37 Mon 01st Oct 2012 LOL @ Excel - I actually thought that too for a minute! 22:42 Mon 01st Oct 2012 good evening Ann how are you? 22:51 Mon 01st Oct 2012 Question Author excel - did you put on your superhero costume and start to fly to my assistance? Hope you had a good day at this 'work' thing. I tried it for 24 years and 33 days and then they discovered that I was nuts and pensioned me off. (You gotta love Civil Service final pay pensions). ;-) xx I have sent the solutions to my problem on to my friend and he can try it out. Thanks 06:26 Tue 02nd Oct 2012 Select the entire vertical set of figures. Click the first (left-most) cell where you want to paste them. Paste values, with transpose (press these keys one at a time: Alt E S V E Enter) Viola! 20:11 Tue 02nd Oct 2012

1 to 9 of 9

Related Questions

## Excel Help

I'm trying to enter a formula where if the number in cell B139 is between 1 and 10,000, you enter 20% in cell F139, if it is between 10,001 and 20,000 you enter 25%, and so on. I can't work out how to...

## Excel Problem

Hello, I wonder if someone ca help me. I have an Excel sheet which has been updated daily for years. Some boxes the text is to be black and some red. Recently in some boxes the text auto changes to...

## I'm Trying To Find An Excel Formula....

...which will extract amounts higher than 0 from a master list on one worksheet, and list them on a different sheet in the same workbook, so that only amounts higher than 0 will be listed and all zero...

## Excel Help

Hi I'm trying to enter a LOOKUP formula which will look up one of three lists, depending on the answer entered in a certain cell. For instance if cell B11 says X I want it to look up from list 1 If...