Spreadsheet: 374589d1422908175-how-to-create-phone-list-with-multiple-categories-data-sheet-sample
Sheet: Sheet1

Data Sample
First Name | Last Name | External ID | Phone 1 | Phone 2 | Definition | Definition 2 | Definition 3
D | Locklear | 1 | 1111111111 |  | 1-All | 5-Children | 9-Nursery Workers |  | 1-All
C | Bullard | 2 | 1111111112 |  | 1-All |  |  |  | 2-Adult Choir
A | Dial | 3 | 1111111113 |  | 1-All |  |  |  | 3-Keenagers
D | Tramel | 4 | 1111111114 |  | 1-All |  |  |  | 4-Youth
V | Locklear | 5 | 1111111115 |  | 1-All |  |  |  | 5-Children
C | Bullard | 6 | 1111111116 |  | 1-All | 6-Faithful Voices |  |  | 6-Faithful Voices
H | Jacobs | 7 | 1111111117 |  | 1-All |  |  |  | 7-Susie's Kitchen
D | Locklear | 8 | 1111111118 |  | 1-All | 7-Susie's Kitchen | 9-Nursery Workers |  | 8-Administrative Council
A | Locklear | 9 | 1111111119 |  | 1-All |  |  |  | 9-Nursery Workers
D | Moore | 10 | 1111111120 |  | 1-All | 4-Youth
K | Locklear | 11 | 1111111121 |  | 1-All
A | [NAME] | 12 | 1111111122 |  | 1-All
B | [NAME] | 13 | 1111111123 |  | 1-All | 9-Nursery Workers | 5-Children
M | Strickland | 14 | 1111111124 |  | 1-All | 7-Susie's Kitchen
K | Dial | 15 | 1111111125 |  | 1-All
P | Cummings | 16 | 1111111126 |  | 1-All | 9-Nursery Workers | 8-Administrative Council
A | Cummings | 17 | 1111111127 |  | 1-All
S | Locklear | 18 | 1111111128 |  | 1-All | 8-Administrative Council
E | Jones | 19 | 1111111129 | 2222222222 | 1-All
B | Strickland | 20 | 1111111130 |  | 1-All
R | Flanagan | 21 | 1111111131 |  | 1-All | 2-Adult Choir | 3-Keenagers
K | [NAME] | 22 | 1111111132 |  | 1-All
S | Bullard | 23 | 1111111133 |  | 1-All | 8-Administrative Council | 3-Keenagers
N | Cummings | 24 | 1111111134 |  | 1-All | 5-Children
R | Smith | 25 | 1111111135 | 2222222223 | 1-All | 4-Youth | 8-Administrative Council
V | Locklear | 26 | 1111111136 |  | 1-All
B | Jones | 27 | 1111111137 | 2222222224 | 1-All | 3-Keenagers
Current Method |  |  |  |  |  |  | Pivot Table based on Table to left
First Name | Last Name | External ID | Phone 1 | Phone 2 | Definition
D | [NAME] | 69 | 3333333333 |  | 1-All
D | [NAME] | 69 | 3333333333 |  | 8-Administrative Council |  | Row Labels
C | Boutselis | 177 | 3333333334 | 4444444444 | 1-All |  | 1-All
C | Boutselis | 177 | 3333333334 | 4444444444 | 5-Children |  | 3333333333
 |  |  |  |  |  |  | (blank)
 |  |  |  |  |  |  | 3333333334
 |  |  |  |  |  |  | 4444444444
 |  |  |  |  |  |  | 5-Children
Desired Result from First Table |  |  |  |  |  |  | 3333333334
1-All |  |  |  |  |  |  | 4444444444
1111111111 |  |  |  |  |  |  | 8-Administrative Council
1111111112 |  |  |  |  |  |  | 3333333333
1111111113 |  |  |  |  |  |  | (blank)
1111111114
1111111115
1111111116
1111111117
1111111118
1111111119
1111111120
1111111121
1111111122
1111111123
1111111124
1111111125
1111111126
1111111127
1111111128
1111111129
1111111130
1111111131
1111111132
1111111133
1111111134
1111111135
1111111136
1111111137
2222222222
2222222223
2222222224
2-Adult Choir
1111111131
3-Keenagers
(111) 111-1137
(111) 111-1131
(111) 111-1133
2222222224
4-Youth
(111) 111-1120
(111) 111-1135
2222222223
5-Children
(111) 111-1111
(111) 111-1134
1111111123
6-Faithful Voices
1111111116
7-Susie's Kitchen
(111) 111-1118
(111) 111-1124
8-Administrative Council
(111) 111-1128
(111) 111-1133
1111111126
1111111135
2222222223