I need to find a way to sort each line by Column A and then by Column D. The problem is that some events happened at the same time. The idea is to provide a timeline of each Incident Number in Column A. How can I get excel to know that if the timestamp is the same, the line that goes first is the one where the value in column B has to equal the value in column C in the row above it. Let's say the example below starts at A1. So C2 is OPENED and so is B3. That is what I want. But C3 is ASSIGNED and B4 is RECOVERED. The D row should be where C row is. Ideas?
<tbody>
</tbody>
Incident: Number | Old Value | New Value | Edit Date | DUR | does previous new equal this lines old |
3585 | OPENED | 5/12/2019 7:57 | |||
3585 | OPENED | ASSIGNED | 5/12/2019 7:59 | 2 | TRUE |
3585 | RECOVERED | ASSIGNED | 5/17/2019 15:05 | 7626 | FALSE |
3585 | ASSIGNED | RECOVERED | 5/17/2019 15:05 | 0 | TRUE |
3585 | ASSIGNED | RECOVERED | 5/22/2019 9:46 | 6881 | FALSE |
3585 | RECOVERED | RESOLVED | 6/6/2019 18:05 | 22099 | TRUE |
3585 | RESOLVED | CLOSED | 7/11/2019 14:33 | 50188 | TRUE |
3658 | OPENED | 5/16/2019 14:11 | |||
3658 | OPENED | ACCEPTED | 5/17/2019 9:10 | 1139 | TRUE |
3658 | ACCEPTED | ASSIGNED | 5/17/2019 9:11 | 1 | TRUE |
3658 | ASSIGNED | PENDING CUSTOMER | 5/18/2019 14:40 | 1769 | TRUE |
3658 | PENDING CUSTOMER | PENDING RELEASE | 5/29/2019 18:29 | 16069 | TRUE |
3658 | PENDING RELEASE | PENDING CUSTOMER | 6/27/2019 15:17 | 41568 | TRUE |
3658 | PENDING CUSTOMER | ASSIGNED | 7/17/2019 11:56 | 28599 | TRUE |
3658 | PENDING CUSTOMER | ASSIGNED | 7/25/2019 9:03 | 11347 | FALSE |
3658 | ASSIGNED | PENDING CUSTOMER | 7/25/2019 9:03 | 0 | TRUE |
3658 | ASSIGNED | PENDING CUSTOMER | 8/6/2019 11:32 | 17429 | FALSE |
3658 | PENDING CUSTOMER | RECOVERED | 8/8/2019 10:17 | 2805 | TRUE |
3658 | RECOVERED | RESOLUTION SUBMITTED | 8/8/2019 10:17 | 0 | TRUE |
3658 | RESOLUTION SUBMITTED | RESOLVED | 8/9/2019 7:15 | 1258 | TRUE |
3658 | RESOLVED | CLOSED | 8/9/2019 10:18 | 183 | TRUE |
<tbody>
</tbody>