Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change from columns to rows and back
I have a vertical list that I want to make horizontal instead. Is there an
easy way to do this other than marking, dragging and dropping each post on a separate column? How do I reverse the process if I instead have a long row that I want to make into one column? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change from columns to rows and back
Try
Copy the listSelect a blank cellRight clickPasteSpecialSelect TransposeOK If this post helps click Yes --------------- Jacob Skaria "SwEdIsH_OfFiCe_UsEr" wrote: I have a vertical list that I want to make horizontal instead. Is there an easy way to do this other than marking, dragging and dropping each post on a separate column? How do I reverse the process if I instead have a long row that I want to make into one column? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change from columns to rows and back
It helps if I have a list with only one column, but what do I do if I have
two columns that I want to be put next to each other, like this: 1 a 2 b 3 c 4 d -- 1 a 2 b 3 c 4 d Is that possible? And can I somehow merge two (or more) lists like this without doing it manually? 1 a 2 a 1 b 2 b 1 c 2 c -- 1 a 1 b 1 c 2 a 2 b 2 c "Jacob Skaria" wrote: Try Copy the listSelect a blank cellRight clickPasteSpecialSelect TransposeOK If this post helps click Yes --------------- Jacob Skaria "SwEdIsH_OfFiCe_UsEr" wrote: I have a vertical list that I want to make horizontal instead. Is there an easy way to do this other than marking, dragging and dropping each post on a separate column? How do I reverse the process if I instead have a long row that I want to make into one column? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change from columns to rows and back
You will need to use formulas OR will have to write custom macros to do this..
Suppose you have a list (ColA and ColB); the range is A1:B10; try the below formula in say(cell C1 and copy that to right as required...) =INDEX($A$1:$B$10,INT((COLUMN(A1)+1)/2),MOD(COLUMN(B1),2)+1) If this post helps click Yes --------------- Jacob Skaria "SwEdIsH_OfFiCe_UsEr" wrote: It helps if I have a list with only one column, but what do I do if I have two columns that I want to be put next to each other, like this: 1 a 2 b 3 c 4 d -- 1 a 2 b 3 c 4 d Is that possible? And can I somehow merge two (or more) lists like this without doing it manually? 1 a 2 a 1 b 2 b 1 c 2 c -- 1 a 1 b 1 c 2 a 2 b 2 c "Jacob Skaria" wrote: Try Copy the listSelect a blank cellRight clickPasteSpecialSelect TransposeOK If this post helps click Yes --------------- Jacob Skaria "SwEdIsH_OfFiCe_UsEr" wrote: I have a vertical list that I want to make horizontal instead. Is there an easy way to do this other than marking, dragging and dropping each post on a separate column? How do I reverse the process if I instead have a long row that I want to make into one column? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I change the Excel columns back to letters? | Excel Discussion (Misc queries) | |||
Columns are numbers, rows letters. How do I change back? | Setting up and Configuration of Excel | |||
Columns are numbers, rows letters. How do I change back? | Setting up and Configuration of Excel | |||
Columns are now numeric, not alpha. how to change back? | Excel Discussion (Misc queries) | |||
how do i change column labels back to letters? currently columns. | Excel Discussion (Misc queries) |