I have been provided with three Excel tables from a volunteer database that can only export reports for one day at a time.
If a volunteer is working multiple shifts that day, he/she will have multiple rows in the spreadsheet. Each row has all of the same information, except for the shift time.
I have 3 files, each one for a different day.
Some of the volunteers are listed in all of the files, and some of them are working more than one shift each day.
I can combine all of the files and sort by name and get one long table.
I need to create a mail merge, an email that I send to each volunteer with all of their shifts.
I need each person to have one row in the table, with Shift 1 Date, Shift 1 Time, Shift 2 Date, Shift 2 Time, etc. all listed in that same row.
Not all of the volunteers work the same number of shifts each day.
Can this be accomplished in Access?
My table:
Joe Smith, 11-1-12, 9-10am
Joe Smith, 11-1-12, 11-12pm
Joe Smith, 11-2-12, 7-8am
Sara Roy, 11-1-12, 9-10am
Sara Roy, 11-1-12, 11-12pm
Needed result:
Joe Smith, 11-1-12, 9-10am, 11-1-12, 11-12pm, 11-2-12, 7-8am
Sara Roy, 11-1-12, 9-10am, 11-1-12, 11-12pm
I know this results in a un-normalized structure, but I need a one-time solution to address this situation.
Any suggestions?
Thank you.