+ Reply to Thread
Results 1 to 2 of 2

Re-arranging Dated Events for Calendar Upload

  1. #1
    Registered User
    Join Date
    08-08-2009
    Location
    Seattle, WA
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re-arranging Dated Events for Calendar Upload

    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
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    08-08-2009
    Location
    Seattle, WA
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: Re-arranging Dated Events for Calendar Upload

    Bump No Response.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1