| T O P I C R E V I E W |
| Neena1695 |
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 |
| 4 L A T E S T R E P L I E S (Newest First) |
| Neena1695 |
Posted - 04/24/2021 : 3:43:29 PM
Thank you Chris, that worked well!
Neena |
| Chris D |
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 |
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 |
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
|
|
|
