Combine sheets with monthly sales information

[jrsmith20]

I'm looking for help creating a workflow that combines different spreadsheets with monthly sales information, where the products being sold might change from month to month.

For example, one input spreadsheet might be 

Type	Item	June purchases
Fruit	Apple	5
Fruit	Cherry	2
Vegetable	Onion	1

and another input:

Type	Item	July purchases
Fruit	Cherry	1
Fruit	Orange	3
Vegetable	Onion	4
Vegetable	Celery	2

and I want to combine them into:

Type	Item	June purchases	July purchases
Fruit	Apple	5	0
Fruit	Cherry	2	1
Fruit	Orange	0	3
Vegetable	Onion	1	4
Vegetable	Celery	0	2

Any assistance would be appreciated!

[atcodedog05 · Accepted solution]

Hi @jrsmith20 

Here is how you can do it.

Workflow:

Hope this helps : )

[jrsmith20]

Great, thank you!

[atcodedog05]

Happy to help : ) @jrsmith20 

Cheers and have a nice day!