| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
stacking multiple column data into a single column
I am Working with excel 2000. Weekly I generate data that is entered into
multiple columns on a worksheet. This data is duplicated in multiple worksheets. This data is in 3 columns that vary in length from week to week. Is it possible (for lack of a better word) to automatically transpose this array of data into a single column of data with no spaces in these different worksheets. I dont want to use the copy and paste functions and manually create this single column. This data is not dynamic and is fixed once its is entered. Thanks for any help Mr. Chubby |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lookup function/sum function | Excel Discussion (Misc queries) | |||
| combining multiple rows of data into one single row of data | Excel Worksheet Functions | |||
| Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
| Return Single Row of Numeric Data to Single Column | Excel Worksheet Functions | |||
| how to convert multiple columns of data into one single column? | Excel Worksheet Functions | |||
Threaded Mode
