Help

[KZ351233]

Del Rte Nbr	commit_tm	Last Scan Time
859	163000	12:31:00 PM
339	200000	10:13:00 AM
414	163000	12:35:00 PM
708	200000	11:37:00 AM
537	200000	2:14:00 PM
728	120000	10:38:00 AM
728	200000	12:42:00 PM
717	163000	10:47:00 AM
416	200000	11:54:00 AM
726	120000	10:09:00 AM
496	163000	10:22:00 AM
438	200000	12:49:00 PM

Here is what I am trying to do. the above is the data that is much larger than what I posted. I am trying to get the output as follows:
Route number, Total 1030 commitment, total 1200 com, 1630 commitment, 2000 commitment, last scan time <1030 where the commitment was greater than 1030.

 

[davesexcel]

What would the result be with the sample data you has shown?

 

[KZ351233]

What would the result be with the sample data you has shown?

339	1
726	1
496	1

 

[KZ351233]

Route#	1030 Commit	1200 Commit	1630 Commit	2000 Commit	<1030 in >1030 Commit
339	0	0	0	1	1
414	0	0	1	0	0
416	0	0	1	0	0
438	0	0	0	1	0
496	0	0	1	0	1
537	0	0	0	1	0
708	0	0	0	1	0
717	0	0	1	0	0
726	0	1	0	0	1

this is the output with the info and the report will have close to 14000 entries and the routes will be listed multiple times.