How can I put pull-out and pull-in time on the same row?

[capronton]

I have the data set below. How can I put pull-out and pull-in time on the same row?

VEHICLE ID Block ACTUAL TIME TRIP TYPE
2201 1002 1:02:46 Pull In
2201 1002 4:10:38 Pull Out
2208 1001 4:20:44 Pull Out
2208 1001 23:15:00 Pull In
2211 1010 5:35:20 Pull Out
2216 1010 18:29:48 Pull In
2228 1011 20:01:44 Pull In
2228 1011 6:59:12 Pull Out
8847 1009 20:26:58 Pull In
8847 1009 5:58:12 Pull Out
8917 1004 0:19:36 Pull In
8917 1004 4:21:44 Pull Out
8926 1005 5:07:44 Pull Out
8926 1005 19:41:30 Pull In
8933 1003 4:49:28 Pull Out
8933 1003 19:21:24 Pull In
8934 1006 1:07:50 Pull In
8934 1008 4:58:40 Pull Out
8939 1007 18:05:44 Pull In
8939 1007 5:26:54 Pull Out
8947 1008 20:45:54 Pull In
8921 1090 15:01:22 Pull Out
2364 1091 16:55:40 Pull Out
2058 1092 16:20:20 Pull Out
2371 2001 21:08:30 Pull In
2371 2001 5:06:34 Pull Out
2302 2002 5:33:42 Pull Out
2423 2030 6:44:46 Pull Out
2423 2030 9:12:56 Pull In
2026 2090 14:22:20 Pull Out
2026 2090 23:53:06 Pull In
8908 3001 4:18:54 Pull Out
2069 3002 1:17:04 Pull In
2055 3003 18:03:10 Pull In
8938 3004 23:56:06 Pull In
8938 3004 5:04:24 Pull Out
8949 3005 5:16:44 Pull Out
8949 3005 23:57:34 Pull In
8849 3006 0:36:50 Pull In
8849 3006 6:02:22 Pull Out

How can I make the report output look like the output below?

VEHICLE ID Block Pull-Out Pull In
2201 1002 4:10:38 1:02:46
2208 1001 4:20:44 23:15:00
2228 1011 6:59:12 20:01:44
8847 1009 5:58:12 20:26:58
8917 1004 4:21:44 0:19:36
8926 1005 5:07:44 19:41:30
8933 1003 4:49:28 19:21:24

Thanks for any assistance.

 

[kray4660]

Try grouping by vehicle and id. Use a formula and stored the actual tine in a shared variable and put in the group header. Then in the group footer, you put the vehicle, id, use another formula to display the shared variable and then actual time (I am assuming only two records per vehicle and id).

 

[capronton]

This works great!

Thanks kray4660!