Important Community update: The process for changing your account details was updated on June 25th. Learn how this impacts your Community experience and the actions we suggest you take to secure your account here.
The logic I used was splitting the data and calculating seperately for potatoes and fish(same set of tools worked) used the transpose, regex, formula and multi row to tackle the issues with date. And used join at the end