Hello,
I am having difficulties creating a certain type of worksheet, and would appreciate if anyone knows if what I need is even possible.
Unfortunately my english is limited and I am struggling to find how to explain my problem. Please be patient with me

I have 2 sheets, the first one contains a table where each row is a certain day in an event with details on that day, while the first cell is the name of that event.
This means that if I have 2 different events, each one lasting for 3 days, then I'll have 6 rows (each row with different details on that day, but first cell in the first 3 rows will be the same, and also in the last 3 rows).

on the second sheet I wanted to create a sort of summery of only the events, so I tried to create an IF function that checks - if the name of the event in a cell is different then the previous row (meaning it is a different type of event) then it will copy it. Problem is, if the name is not different, meaning it's another day of the same event type, it needs to go to the next row and do the same comparison (if the names are the same) and again - either copy or continue to the next row...

However I know how to do it with limited number of cells and a long IF function, but here it is an endless function (compare row n, then row n+1, then n+2,....).

Is there any way to do this in Excel?
Thank you