| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copying Columns of Data to Rows
I have two columns of data and want the first column in a certain row and the
second column in a few rows below the first but in the same column since the information is related. For example: Col A Col B 1xxxx 1yyyy 2xxxx 2yyyy 3xxxx 3yyyy I want it like this Col F Col G Col H Row10 1xxxx 2xxxx 3xxxx Row15 1yyyy 2yyyy 3yyyy Does that make sense? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copying Columns of Data to Rows
Can't you just copy then paste special 'transpose'?
"Walter" wrote: I have two columns of data and want the first column in a certain row and the second column in a few rows below the first but in the same column since the information is related. For example: Col A Col B 1xxxx 1yyyy 2xxxx 2yyyy 3xxxx 3yyyy I want it like this Col F Col G Col H Row10 1xxxx 2xxxx 3xxxx Row15 1yyyy 2yyyy 3yyyy Does that make sense? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copying Columns of Data to Rows
Yeah, that's right. Boy, sometimes you get blinded to the obvious
"DC" wrote: Can't you just copy then paste special 'transpose'? "Walter" wrote: I have two columns of data and want the first column in a certain row and the second column in a few rows below the first but in the same column since the information is related. For example: Col A Col B 1xxxx 1yyyy 2xxxx 2yyyy 3xxxx 3yyyy I want it like this Col F Col G Col H Row10 1xxxx 2xxxx 3xxxx Row15 1yyyy 2yyyy 3yyyy Does that make sense? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copying Columns of Data to Rows
Walter, please rate this as a helpful post.
Thanks "Walter" wrote: Yeah, that's right. Boy, sometimes you get blinded to the obvious "DC" wrote: Can't you just copy then paste special 'transpose'? "Walter" wrote: I have two columns of data and want the first column in a certain row and the second column in a few rows below the first but in the same column since the information is related. For example: Col A Col B 1xxxx 1yyyy 2xxxx 2yyyy 3xxxx 3yyyy I want it like this Col F Col G Col H Row10 1xxxx 2xxxx 3xxxx Row15 1yyyy 2yyyy 3yyyy Does that make sense? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I avoid copying data from hidden rows/columns? | Excel Discussion (Misc queries) | |||
| copying information from rows to columns | Excel Discussion (Misc queries) | |||
| Copying data from one worksheet to another from rows to columns | Excel Worksheet Functions | |||
| Copying from columns to Rows | Excel Discussion (Misc queries) | |||
| Counting Rows/Columns for Copying Formulas | Excel Discussion (Misc queries) | |||
Linear Mode
