Trivial question

[Guest]

Hi!

I know this is a very trivial question but I have not been able to find the
answer anywhere

I have an excel sheet featuring a row (row 1) with the following sequence of
numbers:

CELL A1 B1 C1 D1 E1 F1 G1
VALUE: 1 2 3 4 5 6 7

I want to arrange these numbers vertically , something like this


CELL VALUE
L1 1
L2 2
L3 3
L4 4
L5 5
L6 6
L7 7

Which is the formula I should insert into cell L1 and drag along L column to
accomplish this?

Thanks for your support

 

[Guest]

Without a formula

Select the values & copy them
Select L1 and use Edit>Paste Special>Transpose

 

[Pete_UK]

If you just want to do it as a one-off then you can <copy> the values,
move to cell L1 then Edit | Paste Special | Values (check) and
Transpose (check) then OK and <Esc>.

You can also use the TRANSPOSE( ) function - details in Excel Help.

Hope this helps.

Pete