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?

If this isn't possible, what is the best way to graph the data onto one graph where time is the X axis?