Organize Dates & Times into Columns

I'm trying to organize a list of dates/times for a karaoke database I'm organizing. I have a list of 1,276 dates/times for bars that offer karaoke at various days of the week and times. Right now it's in various formats only in one cell each as such: Wed/Fri/Sat 8pm-2 Wed/Thu/Sat/Sun 9pm-130 Tue/Thu 9pm-2 Thursdays 8pm-1 7 Nites a Week 8pm-230 Fridays 10pm-2 Wednesdays 10pm-1 Tuesdays 7pm-9pm Tue/Thu 9pm-2, Fri 12am-2, Sat 10pm-2 7 Nites a Week 8pm-2 I need to have a column for each day of the week with the corresponding start/finish times for each applicable day. Pretty straightforward stuff. I've already started it, and it seems to be about a 4 hour job.