combine and sort two tables

[MrShorty]

The sample spreadsheet illustrates (with random numbers) what I am looking to do. I process two sets of data that yield two separate tables. My goal is to combine those two tables and sort them by x. I would normally do like I have done in my sample by using an intermediate table that combines the two tables, then sort the table. I am wondering how difficult it is to remove the intermediate step. (Perhaps I am just being corrupted by visiting a forum like this and seeing everyone else going to extreme lengths to avoid/hide the intermediate steps of an operation). Any thoughts on this, or is it really just easier to create the intermediate table along the way?

[Ace_XL]

The SMALL function can work with non-contiguous arrays too

In O5
=SMALL(($A$5:$A$16,$E$5:$E$8),O5)

In P5
=IFERROR(VLOOKUP($P5,$A$5:$C$16,2,FALSE),VLOOKUP($P5,$E$5:$G$8,2,FALSE))

In Q5
=IFERROR(VLOOKUP($P5,$A$5:$C$16,3,FALSE),VLOOKUP($P5,$E$5:$G$8,3,FALSE))

Copy down

[MrShorty]

Thanks, Ace_XL, that looks good. I think the key was seeing how to use a non-contiguous array in the small function.