Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi there,
I'm wondering if there is a way to take a list numbers which are in multiple columns and put them into order in one column? Sample data: 1........6..........11 2........7..........12 3........8..........13 4........9..........14 5.......10.........15 Into: 1 2 3 4 5 6 7 ..... 15 Is this possible? I dont mind using helper columns here. Obviously my data is not so nicely order to begin with either:) Thanks for any ideas. Ive wasted my entire day on this. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Filtering Multiple Columns | Excel Worksheet Functions | |||
using functions to compare multiple columns for mismatch of cells | Excel Worksheet Functions | |||
making multiple columns when printing long datasheet | Excel Discussion (Misc queries) | |||
Convert 1 row of data into Multiple columns | Excel Discussion (Misc queries) | |||
Drop-down selection fills data across multiple columns | Excel Discussion (Misc queries) |