Arranging rows by closest timestamp

[adyady55]

Hello everyone!

Bellow i attach how my worksheet looks.
What i need to do: for every timestamp and value from Speed, i need to associate ONE value and timestamp from the other 4. I need to closest timestamp(and it's value ofc) from the other 4 colums.
Ex: for the first one 01-04-2015 11:43 I would have : 01-04-2015 11:42(not in the screenshot) from suction press, 01-04-2015 11:43(not in the screenshot) from discharge press ,01-04-2015 11:38 from suction temp, 01-04-2015 11:46 from discharge temp.

Normally I would do this manually and just delete the values/timestamp from each colum that i dont need, but since there are tens of thousands of values in the other colums except Speed, i need a way to do this automatically

Thank you!

[Pepe Le Mokko]

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

[adyady55]

I have attached a worksheet with 2 examples of before and after. The rows in after are arranged by closest timestamp , being it =,> or < . Now i just did it manually by Deleting -> shift cells up all the timestamps/values that i dont need. If there is a way to do this automatically it would be lifesaving.

Thank you again!