Without a formula

Select the values & copy them
Select L1 and use EditPaste SpecialTranspose


"Jess" wrote:

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