I have attached a picture of part of the document I am tying to sort. There are about 4000 rows. The two time columns (A and K) and the corresponding data to the right of each I need to match up to the exact time if possible. The data in A is in a strange format, I don't know how to take out the dates and the T and Z without going through and doing each one individually. And then is it possible to align the rows with matching times? And just delete the rest.


Capture.PNG