paste append for different content

Question

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

CategorySalesApple1000Grape800Orange600

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

CategoryBudgetBanana650Grape900Orange1050

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

CategorySalesApple1000Grape800Orange600CategoryBudgetBanana650Grape900Orange1050

MarqueeCrew · Accepted Answer

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 Answer

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