using awk how can i format this data so i can have 14-0273 under ID , 06/28/2014 under date and for all other title

ID,Date,DateType,Age,Sex,Race,ResidenceCity,ResidenceCounty,ResidenceState,DeathCity,DeathCounty,Location,LocationifOther,DescriptionofInjury,InjuryPlace,InjuryCity,InjuryCounty,InjuryState,COD,OtherSignifican,Heroin,Cocaine,Fentanyl,FentanylAnalogue,Oxycodone,Oxymorphone,Ethanol,Hydrocodone,Benzodiazepine,Methadone,Amphet,Tramad,Morphine_NotHeroin,Hydromorphone,Other,OpiateNOS,AnyOpioid,MannerofDeath,DeathCityGeo,ResidenceCityGeo,InjuryCityGeo
14-0273,06/28/2014 12:00:00 AM,DateReported,,,,,,,,,,,substance,,,,,”Acute fent, hydrocod, benzodiazepine”,,,,Y,,,,,Y,Y,,,,,,,,,Accident,”CT
(41.575155, -72.738288)”,”CT
(41.575155, -72.738288)”,”CT
(41.575155, -72.738288)”
13-0102,03/21/2013 12:00:00 AM,DateofDeath,48,Male,Black,NORWALK,,,NORWALK,FAIRFIELD,Hospital,,,,,,,Cocaine Intoxication,,,Y,,,,,,,,,,,,,,,,Accident,”Norwalk, CT
(41.11805, -73.412906)”,”NORWALK, CT
(41.11805, -73.412906)”,”CT
(41.575155, -72.738288)”
16-0165,03/13/2016 12:00:00 AM,DateofDeath,30,Female,White,SANDY HOOK,FAIRFIELD,CT,DANBURY,,Hospital,,Substance Abuse,Unknown,UNKNOWN,,,Acute Heroin and Cocaine Intoxication,,Y,Y,,,,,,,,,,,,,,,Y,Accident,”Danbury, CT
(41.393666, -73.451539)”,”SANDY HOOK, CT
(41.419998, -73.282501)”,
16-0208,03/31/2016 12:00:00 AM,DateofDeath,23,Male,White,RYE,WESTCHESTER,NY,GREENWICH,,Hospital,,substance abuse,Residence,RYE,,,Acute Fentanyl and Morphine Intoxication,,Y,,Y,,,,,,,,,,,,,,Y,Accident,”Greenwich, CT
(41.026526, -73.628549)”,,
13-0052,02/13/2013 12:00:00 AM,DateofDeath,22,Male,”Asian, Other”,FLUSHING,QUEENS,,GREENWICH,FAIRFIELD,Hospital,,Transdermal Absorption,Other,,,,Fentanyl Intoxication,,,,Y,,,,,,,,,,,,,,,Accident,”Greenwich, CT
(41.026526, -73.628549)”,,”CT

Go to Source
Author: nish patel