LightBright
New Member
- Joined
- Sep 21, 2020
- Messages
- 1
- Office Version
- 365
- Platform
- Windows
Greetings - I volunteered to help a friend sort volunteer availability data, and we are trying to schedule volunteers (500+). The form is designed in a way that I am not sure how to best pivot the data to map out volunteer days and shifts. Ideally, I would like to easily sort the data to automate assigning volunteers to different shifts and quickly understand where we are lacking volunteers.
I pasted a data sample below. As you can see, respondents may have listed multiple shifts where they are available; however, I do not know how to breakout that data to create a functional pivot table.
I pasted a data sample below. As you can see, respondents may have listed multiple shifts where they are available; however, I do not know how to breakout that data to create a functional pivot table.
Region | Timestamp | First Name | Last Name | Email Address | Phone Number | County (please select the area where you will be in during Testing (Oct. 15-31) and Go Live | Are you eligible to test ? | Zip Code | Would you be comfortable serving INSIDE? | Would you be available to serve a neighboring test? | Testing is October 15-31. Which of these WEEKDAY shifts work for you? [Thurs, 10/15] | Testing is October 15-31. Which of these WEEKDAY shifts work for you? [Fri, 10/16] | Testing is October 15-31. Which of these WEEKDAY shifts work for you? [Mon, 10/19] | Testing is October 15-31. Which of these WEEKDAY shifts work for you? [Tues, 10/20] | Testing is October 15-31. Which of these WEEKDAY shifts work for you? [Wed, 10/21] | Testing is October 15-31. Which of these WEEKDAY shifts work for you? [Thurs, 10/22] | Testing is October 15-31. Which of these WEEKDAY shifts work for you? [Fri, 10/23] | Testing is October 15-31. Which of these WEEKDAY shifts work for you? [Mon, 10/26] | Testing is October 15-31. Which of these WEEKDAY shifts work for you? [Tues, 10/27] | Testing is October 15-31. Which of these WEEKDAY shifts work for you? [Wed, 10/28] | Testing is October 15-31. Which of these WEEKDAY shifts work for you? [Thurs, 10/29] | Testing is October 15-31. Which of these WEEKDAY shifts work for you? [Fri, 10/30] | Testing is October 15-31. Which of these WEEKEND shifts work for you? [Sat, 10/17 ] | Testing is October 15-31. Which of these WEEKEND shifts work for you? [Sun, 10/18] | Testing is October 15-31. Which of these WEEKEND shifts work for you? [Sat, 10/24] | Testing is October 15-31. Which of these WEEKEND shifts work for you? [Sun, 10/25] | Testing is October 15-31. Which of these WEEKEND shifts work for you? [Sat, 10/31] | Which of these Go Live (November 1st) shifts work for you? | Do you have a LEGAL BACKGROUND | Please Add Anything Else |
1 | ######## | Help | Doe | 2345678901 | Test | Yes | 12345 | EITHER Inside OR Outside | No | None | None | None | None | 4PM-7:30PM | None | None | None | None | None | None | 4PM-7:30PM | 12PM - 4PM | None | None | None | 8AM - 12PM | None | No | ||
100 | ######## | Excel | Jane | 123456789 | Help | Yes | 12365 | Outside Only | No | None | 8AM-12PM, 12PM-4PM, 4PM-7:30PM | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ALL DAY | Yes | ||
10 | ######## | Test | John | 1231231234 | Excel | No | 12355 | EITHER Inside OR Outside | Yes | None | None | None | 12PM-4PM | None | None | None | None | None | 8AM-12PM, 12PM-4PM, 4PM-7:30PM | 8AM-12PM, 12PM-4PM, 4PM-7:30PM | 8AM-12PM, 12PM-4PM, 4PM-7:30PM | None | None | None | None | 8AM - 12PM, 12PM - 4PM, 4PM - 7:30PM | ALL DAY | Yes |