Morning All,
Attached is a demo csv, some data is demo'd below
| Date | Purchase | Type | Amount kg |
| 01/05/2021 | Bananas | Fruit | 0.9 |
| 01/05/2021 | Apples | Fruit | 0.5 |
| 01/05/2021 | Strawberries | Fruit | 0.2 |
| 01/05/2021 | Kiwis | Fruit | 0.4 |
| 01/05/2021 | Limes | Fruit | 0.6 |
| 01/05/2021 | Potatoes | Veg | 0.8 |
| 01/05/2021 | Leeks | Veg | 0.2 |
| 01/05/2021 | Cauliflower | Veg | 0.5 |
What I would like to do is for each date, have a "Purchase" where all the different types are added together, like the following and added to the data, so it would look like this:
| Date | Purchase | Type | Amount kg |
| 01/05/2021 | Fruit | Fruit | 2.6 |
| 01/05/2021 | Veg | Veg | 1.5 |
| 01/05/2021 | Bananas | Fruit | 0.9 |
| 01/05/2021 | Apples | Fruit | 0.5 |
| 01/05/2021 | Strawberries | Fruit | 0.2 |
| 01/05/2021 | Kiwis | Fruit | 0.4 |
| 01/05/2021 | Limes | Fruit | 0.6 |
| 01/05/2021 | Potatoes | Veg | 0.8 |
| 01/05/2021 | Leeks | Veg | 0.2 |
| 01/05/2021 | Cauliflower | Veg | 0.5 |
Many thanks
