How to combiene different rows in to one

Hi, I’m trying to solve a problem with data that is diffusely scattered. I could see that the dates that exist in the table are the only “pattern” that I can use, but I honestly don’t know how. I am attaching an example of what the table looks like and how I would like it to look. Thank you very much