How can I turn the following live data (collected via a linked google form) about purchases made:

into a table that looks like the following in google sheets, without using the pivot table functionality?

Importantly:

1. the table would need to update whenever the data updates
2. the value for each cell should be the sum of the spending in the corresponding category for the corresponding day (e.g. $5 and $3 were spent on snacks on 16/4, so the total is reported as $8)
3. as new days are added to the data, they would be added to the table as well
4. as new categories are added to the data, they would be added to the table

I am new to google sheets/excel so an explanation of any potential solutions would be appreciated (I have a decent amount of programming experience so doesn’t have to be super detailed).