Date and Time Issues

Hi there,
I have a data set with values generated at different time intervals. 1 set at 1s, 1 at 5s and another at 2min intervals. I have attached the data in its raw form on the first sheet, and the second sheet has how I would like the data to appear (all the values generated at the same time in the same row). Is there a way to automate lining these values? Some way to have the values at the same times automatically added to the same row?