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!
