Help 1.xlsx

Working on this project at work. Sheet1 has all the information I need, it is just in a vertical layout and it does have some extra stuff as well. Column A is Year, month, and day. Column B is universal time, while Column C is the local time. And Column D is the temperature taken at those times. There is some extra information, like I only need temps every hour, and only the temps from 451 to 2351.

Sheet 2 has what I am trying to get to, with one year completed, 4 more years to go. I basically want all the vertical information that is in Sheet1 to be separated by day and placed horizontally. It also has all the times that I need, plus a couple extra just because the original filter couldn't remove all of them. Is there a way to speed the process up other than doing it by hand? This information is from just one location and this project will come up again when we look at different locations.

Does anyone have any suggestion on how to speed the process up?

Thank you