Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Trivial question
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Trivial question
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Trivial question
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Finding and deleting question marks | Excel Discussion (Misc queries) | |||
Pivot table question | Excel Discussion (Misc queries) | |||
Follow-Up (Clarification) to MIN question | Excel Discussion (Misc queries) | |||
Benefits many people - Question | Excel Discussion (Misc queries) | |||
How do I find and replace a question mark in Excel? | Excel Discussion (Misc queries) |