I'm using app sheets to see what I do in a day. I select the task I am starting on the app and app sheets dumps the data into a table in google sheets.
I have made an example of what this looks like. Sheet1 is what it looks like At the moment and sheet2 is what I would like it to look like (or something else that will help charts read it).
I have been pulling my hair out trying to do this so if you know how please tell me.