| Author |
 Topic  |
|
|
Neena1695
Canada
117 Posts |
 Posted - 04/22/2021 : 2:34:39 PM
|
Hello Origin Users,
How to combine data from multiple columns into one column in increasing order? Attached an example data table, where I want to combine columns A to G into column H.
Thank you! 
Neena |
|
|
Chris D
428 Posts |
Posted - 04/22/2021 : 4:08:30 PM
|
Hi,
From the worksheet menu, you can choose Stack Columns setting the Recalculate to None.
To sort, select the output column, right-click and Choose Sort Column.
I hope this helps.
Thanks,
Chris Drozdowski
Originlab Technical Support
|
 |
|
|
Neena1695
Canada
117 Posts |
Posted - 04/23/2021 : 11:50:52 AM
|
Hi Chris,
Thank you for helping out!
Although that did not give me the required output. Please see the attached file, after stacking and sorting as you suggested, I see some repetition of numbers which I do not understand.
Many thanks
Neena |
|
|
|
Chris D
428 Posts |
Posted - 04/23/2021 : 1:09:23 PM
|
Hi,
Try this- in the Stack Columns dialog, check "Stack By Rows". It'll do what you want and you don't even have to sort it. Sorry I missed that the first time.
~Chris
Thanks,
Chris Drozdowski
Originlab Technical Support
|
|
|
|
Neena1695
Canada
117 Posts |
Posted - 04/24/2021 : 3:43:29 PM
|
Thank you Chris, that worked well!
Neena |
|
|
| |
Topic |
|
Combine multiple columns into one