I have the following data:
<tbody>
Event ID
Vehicle
Status Code
P16039954
1102
DP
P16039954
1102
AM
P16039954
1102
DP
P16039954
1102
AR
P16039954
1102
AM
P16039954
1301
DP
P16039954
1301
AM
P16039955
1299
DP
P16039956
1299
DP
P16039956
1301
DP
</tbody>
I would like to...