Pivot Table - multiple date columns and grouping

[virtum]

Hi all,

I have a set of data that is organized by branch # and name, and includes 3 critical dates for each branch. The data is set up like this (with lots of other columns of data in and around it - yes it's already in Excel... I'm just using Code to make it easier to read)

Branch #      Branch Name     Visit 1       Visit 2    Visit 3
12345         San Francisco   11/05/05      12/13/05   1/27/06
55555         New York        12/13/05      12/24/05   2/08/06
... (for about 300 branches)

I'm trying to create an integrated schedule that would look like the example below, and know a pivot table is the solution, but can't seem to get it right.

11/05/05   12345  San Francisco   Visit 1
12/13/05   12345  San Francisco   Visit 2
12/13/05   55555  New York        Visit 1
12/24/05   55555  New York        Visit 2
1/27/06    12345  San Francisco   Visit 3
2/08/06    55555  New York        Visit 3
... (for about 900 events)

Critical pieces:
- Incorporates all 3 dates for each row (site).
- Is sorted by date
- Uses the Branch #/Name AND the visit type (column heading of the date) to describe each event

Bonus points:
- For being able to group the events by week,
- For being able to total the number of events by week or month.

If this were a snap shot of the data, I know how to do this manually, but want to be able to update dates, and have the integrated schedule change accordingly.

Any help at all is greatly appreciated!

Virtum =)

[Note - there is some simple VB in the workbook already, so if that is the solution, I can implement that as well.]