This the data I have –
A B C 12/15/2019 Apple 37 12/15/2019 Banana 11 12/15/2019 Carrot 1 12/15/2019 Damson 4 12/15/2019 Fig 1 12/16/2019 Apple 48 12/16/2019 Banana 6 12/16/2019 Carrot 3 12/16/2019 Eggplant 1 12/16/2019 Fig 5
It goes on for years. I have missing data points – See Damson and Eggplant don’t exist for both dates.
I don’t know if Google SpreadSheets can turn that data into a time line chart as is, of wether I’d need to transform into a table with all of A-F represented as columns on their own and missing entries set to zero explicitly.
I could probably write some Python to make a CSV representation as described, like that (even without the fancy libraries), but I wonder if it is possible in a s/sheet tech.
Is there a simple formula? What is the name for this transform?