| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Return Single Row of Numeric Data to Single Column
Hi All,
I have a Row of numeric data ( in individual columns) that I would like returned to individual cells in a single column. My data starts in Column C Row 13 to Column DV Row 13. However, every other Column in the Row of data is blank. Is it possible to return the data excluding the blank columns, so there are no blank cells when the data is returned to a single column? Sample Data Layout: C13 BLANK, D13 70, E13 BLANK, F13 45, G13 BLANK, H13 50, I13 BLANK, J13 63, K13 BLANK etc. Thanks Sam -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...tions/200512/1 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Match Each Numeric occurrence and Return Individual Rows of Data | Excel Worksheet Functions | |||
| Return Single Instance of Numeric Values from a Column | Excel Worksheet Functions | |||
| Using a Vlookup to return values in a data list? | Excel Worksheet Functions | |||
| merge data from multiple columns to single column | Excel Worksheet Functions | |||
| how to convert multiple columns of data into one single column? | Excel Worksheet Functions | |||
Threaded Mode
