How to combine column values

[samxhander09]

Hi Community,

I've been doing an exercise and I couldn't figure out how to combine all row values from different columns into one.

Example:

How do I get this output?

Apple         Orange

12               1

34               2

23               3

                  12

Thank you everyone.

[samxhander09]

@PhilipMannering 

Hi, yes, this is how I want my output to look like.

[PhilipMannering]

Then just replace the Text Input Tool (in my workflow) with the Excel file that you shared. After that, Sort Tool and Select Tool will do the rest.

[samxhander09]

@PhilipMannering 

I actually can't replace it with excel, since the input is coming from a different data stream. If the input looks like that, is there other way to achieve my desired output other than converting my input to excel?

[PhilipMannering]

Can you then connect the different data stream to my workflow pasted into yours (with the Text Input Tool removed)?