I have a google sheet that is autofilled from a google form. A person is allowed to do the questionnaire as often as they'd like, but I would like to not make them answer every question every time. Every time they fill out the questionnaire they must provide their identity.
I've created an example of a similar sheet here.
In this case I have 3 users apple, orange, and banana. Each has both a price and an amount. What I want to do is find each unique case insensitive name, and their most recent input in each column. How would I go about doing this?