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:
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