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 |
Solved! Go to 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