Suppose I have date/military time/values from three different sources A, B, and C, where the times sometimes match and sometimes don't. The goal here is to sort/order them so that, for every minute that data is generated, I can compare the values from all three sources by having all data for that minute isolated on its own row. [This will in turn allow me to create another column which tells me if, sometime during that minute, all three values were above a certain value.] So I start with this:

DATE A TIME A VAL A DATE B TIME B VAL B DATE C TIME C VAL C
3/26/12 2:36 47 3/26/12 2:36 33 3/26/12 2:31 33
3/26/12 4:37 49 3/26/12 4:37 37 3/26/12 4:37 38
3/26/12 4:37 50 3/27/12 0:13 22 3/27/12 0:13 20

Then I would like to sort this data so that values with the same time are aligned on the same row, as follows:

DATE TIME A B C
3/26/12 2:31 33
3/26/12 2:36 47 33
3/26/12 4:37 49 37 38
3/26/12 4:37 50
3/27/12 0:13 22 20

Note that where there are two values from source A with the same time, I need each to be on a separate row, as ultimately I will be creating this (where I have copied the 4:37 values from B and C from the 3rd row of data to the 4th [marked in bold], so that I can compare those values to both the first and second 4:37 values from A:

DATE TIME A B C
3/26/12 2:31 33
3/26/12 2:36 47 33
3/26/12 4:37 49 37 38
3/26/12 4:37 50 37 38
3/27/12 0:13 22 20

This way, for every minute that data is generated, I can compare all values from all three sources. The ultimate goal is to be able to then have another column which tells me if, sometime during that minute, all three values were above a certain value.