paste append for different content

[ll1100000]

In table 1 the sales $ is ranked descending for each Category

Category	Sales
Apple	1000
Grape	800
Orange	600

In table 2, the Budget $ is ranked ascending for each Category.

Category	Budget
Banana	650
Grape	900
Orange	1050

Is it possible to union these two tables together as below in one sheet for the same file?  Thank you.

Category	Sales
Apple	1000
Grape	800
Orange	600
Category	Budget
Banana	650
Grape	900
Orange	1050

[MarqueeCrew · Accepted solution]

You can UNION the data together easily.

Change the "Auto Config by Name" option to:  Manually Configure Fields.

Note:  AutoConfig by Position will work too in your simple case.

The output won't have the "column headers" included, but the data will be merged in the output.

Cheers,

Mark

[Joe_Mako · Accepted solution]

One option is to use the Table and Render tools to stack the tables in an output.