>>id timefield field1 field2 field3 field4 >>1 01/01/00 15:45 hi 0 check field >>1 01/01/00 7:48 bye 1 double main >>2 01/01/00 14:51 hi 0 check field >>2 01/01/00 8:48 bye 1 NULL main >>3 NULL get 0 fake NULL >>3 NULL get2 1 fake NULL >>4 01/01/00 16:05 get1 1 fake NULL >>>>need to get into this form:
>>id amtime amfield1 amfield2 amfield3 amfield4 am1time am1field1 am1field2 am1field3 am1field4 pmtime pmfield1 pmfield2 pmfield3 pmfield4 pm1time pm1field1 pm1field2 pm1field3 pm1field4 >>1 7:48AM hi 0 check field 3:45PM bye 1 double main >>2 8:48AM hi 0 check field 2:51PM bye 1 main >>3 get 0 fake get2 1 fake >>4 4:05PM get1 1 fake >>>>field2 is the TripAsgn_PickUp and id is the stutrip_stu_autoid. id identifies the records to group together, while field2 says if they are am or pm and timefield is the order within the am or pm.