Bringing together multiple columns into one from least to greatest?
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.
|