Thank you everyone, I think I have what I need to make this work now. I felt it would have something to do with row_number(), but it hadn't occurred...
Thankyou for the quick response:-)Unfortunately this combines all of the "blues" 🙁 I still need future occurances to be seperate when they do not have an instance directly before or...