googlesheet new user here. Am trying to wrangle to some data in the most efficient way possible. I have done this transformation already via a formula of lookups and if statements but have to believe there is a better way with a query function or similar? any guidance would be greatly appreciated. The image shows the transformation required - would also be grateful if you could suggest how this question could be better worded. Thank you.