Please see attachment,
Currently I am having to export the data in excel to do this work. I would love to see if it can be done in Looker.
I assume this can only be done in lookML which I have am completely new to. Any help or guidance literature to where to get started would be great!
What does the data look like when you export it from Looker? I am not sure if the screenshot is something you do already after the export? If so show us what the data looks like in Looker and the desired end result.