I have a worksheet that is poorly formatted that i've imported from an outside source. I need to re-arrange the dated material so I can upload a csv file to populate a calendar with events.
I have been able to strip out a lot of extraneous data with a few strokes of the keyboard, but was hoping I could create some equations to manipulate the start and end times of the events.
I have attached the worksheet I'm working with. The yellow shaded area is the 'raw' data, and the orange shaded areas is an example of what I need.
The problem I can't seem to sleuth is how can I make it automatic/repetitive (i.e. create one equation in top row and drag it down), and getting the Date to match up with the correct Start Time and End Time. Example: 08/03/2009 needs to be repeated 4 times to match up with the 4 events on that day, three of which start at 5:00 PM, and one starts at 8:00 PM.
Super-duper most appreciate any help on this.
Thanks
Bookmarks