cjackson10111
New Member
- Joined
- Feb 10, 2014
- Messages
- 2
I have a list of names/ phone numbers which is formatted as:
<tbody>
</tbody>
All phone numbers are part of the "all" category (would be glad to delete if possible)
John Smith is a part of the list "all" and list "choir"
Sara Green is a part of list "all" and list "youth"
This information is used for a One Call system which sends out a phone call simultaneously to any of the groups selected. The company which manages this system requires the information to be sent to them in the format:
All
(910) 111-1111
(910) 111-1112
(910) 111-1113
Choir
(910) 111-1111
(910) 111-1112
Youth
(910) 111-1113
I would like to generate a table which compiles all of the numbers (about 300) into the list which will be sent to our One Call system.
I recently created a pivot table which creates this list, however it required the original table to be modified to:
<tbody>
</tbody>
This solution would require any persons involved in several groups to have duplicate entries for each group.
I had considered creating several "Definition" columns and a series of pivot tables; one for Definition 2: Youth, one for Definition 3: Youth, one for Definition 2: Choir; one for Definition 3: Choir, etc.
This seems like it may not be necessary, but it would generate the list I need, if I can generate several pivot tables whose location is relative to the table above it, which I have been unable to figure out.
Office 2010
Windows 7
First | Last | Phone 1 | Phone 2 | All | Choir | Youth | etc. |
John | Smith | 910-111-1111 | 910-111-1112 | x | x | ||
Sara | Green | 910-111-1113 | x | x |
<tbody>
</tbody>
All phone numbers are part of the "all" category (would be glad to delete if possible)
John Smith is a part of the list "all" and list "choir"
Sara Green is a part of list "all" and list "youth"
This information is used for a One Call system which sends out a phone call simultaneously to any of the groups selected. The company which manages this system requires the information to be sent to them in the format:
All
(910) 111-1111
(910) 111-1112
(910) 111-1113
Choir
(910) 111-1111
(910) 111-1112
Youth
(910) 111-1113
I would like to generate a table which compiles all of the numbers (about 300) into the list which will be sent to our One Call system.
I recently created a pivot table which creates this list, however it required the original table to be modified to:
First | Last | Phone 1 | Phone 2 | Definition |
John | Smith | (910) 111-1111 | (910) 111-1112 | All |
Sara | Green | (910) 111-1113 | All | |
John | Smith | (910) 111-1111 | (910) 111-1112 | Choir |
Sara | Green | (910) 111-1113 | Youth |
<tbody>
</tbody>
This solution would require any persons involved in several groups to have duplicate entries for each group.
I had considered creating several "Definition" columns and a series of pivot tables; one for Definition 2: Youth, one for Definition 3: Youth, one for Definition 2: Choir; one for Definition 3: Choir, etc.
This seems like it may not be necessary, but it would generate the list I need, if I can generate several pivot tables whose location is relative to the table above it, which I have been unable to figure out.
Office 2010
Windows 7