Aggegation in table

I have data from my door sensor. Door writes its status every 1 hour or when it opens/closes.
Please look at the picture: https://ibb.co/hf1RFKK
How to group rows that I see only rows when my door status changes and use text alias?
Something like that:
12:00 closed
11:07 opened