| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Converting a number of rows into a single column
Hi there everyone
I have a table of data 10 rows and 10 columns wide with some blanks in between. Is there a way to format it to a single column of data (order doesn't matter). The output essentially just needs to be one column of data, 1 cell wide. If the blanks can be eliminated, nothing like it... if not, even then I can live with that!! Thanks guys, Appreciate. Raj. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lookup Data in two seperate Spreadsheets | Excel Worksheet Functions | |||
| Column picked randomly with probability relative to number of entr | Excel Worksheet Functions | |||
| HOW DO I RE-NUMBERED MY NUMBER COLUMN AFTER I ADDED ROWS? | Excel Discussion (Misc queries) | |||
| Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
| formula to use when number of rows changes dynamically | Excel Worksheet Functions | |||
Threaded Mode
