| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combine multiple columns into two long columns, Repeating rows in first column
I need help combining data in multiple columns into two long columns with the rows in the first column repeating: Example Start Column1, Column2, column3, Column4, Column5 Joe, 1000, 15000, 300, 20 Mike, 400, 5000, 37, 500 Gary, 90, 3000, 100, 66 End Column1, Column2 Joe, 1000 Joe, 15000 Joe, 300 Joe, 20 Mike, 400 Mike, 5000 Mike, 37 ................... Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sorting Data From One Column into Multiple Columns | Excel Worksheet Functions | |||
| how to combine several columns into a single column | Excel Discussion (Misc queries) | |||
| Repeating Rows and Columns on each page of print out | Excel Discussion (Misc queries) | |||
| generate multiple rows based on cell value | Excel Worksheet Functions | |||
| Convert multiple columns to rows | Excel Worksheet Functions | |||
Linear Mode
