Spreadsheet: 138087d1327509364-tranpose-pt-examples-handoffs
Sheet: Sheet1

SOURCE | TARGET | Helper1 | Helper2
ENNDANANDNGR1 | ENNDHANUMANG3 |  |  |  | Here a Pivot Table shows data similar to what you have designed below
ENNDANANDNGR1 | ENNDANANDNGR3 |  |  |  | Count of TARGET | Column Labels
ENNDANANDNGR1 | ENNDANANDNGR2 |  |  |  | Row Labels | ENNDANANDNGR1 | ENNDANANDNGR2 | ENNDANANDNGR3 | ENNDBAPANA1 | [NAME] | ENNDBAPANA3 | ENNDCHINARWAR2 | ENNDDEGLURNK1 | ENNDDEGLURNK3 | ENNDHANUMANG1 | [NAME] | ENNDHANUMANG3 | [NAME] | ENNDIBSOANAND2 | ENNDIBSOANAND3 | ENNDIBSOANAND4 | [NAME] | ENNDIBSODATTA2 | ENNDIBSODATTA3 | ENNDIBSODRM3 | ENNDIBSOGNHTL1 | ENNDIBSOGNHTL2 | ENNDIBSOGNHTL3 | ENNDIBSOGOPA2 | ENNDIBSOMANIK2 | ENNDIBSOROY1 | ENNDIBSOROY3 | ENNDIBSOROY4 | ENNDIBSOSHIVN3 | ENNDIBSOSHIVN4 | ENNDIBSOVASNT1 | ENNDIBSOVASNT2 | ENNDIBSOVASNT3 | ENNDIBSOVSHU2 | ENNDIBSOYATR4 | ENNDRAJENDRA1 | ENNDSAKTINGR1 | [NAME] | ENNDVIPRD1 | ENNDVIPRD2 | NRLYKAMTHA2 | Grand Total
ENNDANANDNGR1 | ENNDIBSOGOPA2 |  |  |  | ENNDANANDNGR1 |  | 1 | 1 |  |  |  | 1 |  |  | 1 |  | 1 |  |  |  |  |  |  |  | 1 |  | 1 | 1 | 1 |  | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  | 1 |  |  | 15
ENNDANANDNGR1 | ENNDIBSOROY3 |  |  |  | ENNDANANDNGR2 | 1 |  | 1 |  |  | 1 |  |  |  | 1 | 1 | 1 |  |  | 1 |  |  |  |  |  | 1 | 1 | 1 |  |  |  |  |  |  |  |  | 1 | 1 |  |  |  |  |  | 1 |  |  | 13
ENNDANANDNGR1 | ENNDIBSOGNHTL3 |  |  |  | ENNDANANDNGR3 | 1 | 1 |  |  |  |  | 1 |  |  |  |  |  | 1 | 1 | 1 | 1 |  |  |  |  |  |  | 1 | 1 | 1 |  |  |  |  |  | 1 | 1 |  |  |  | 1 |  |  | 1 |  |  | 14
ENNDANANDNGR1 | ENNDIBSODRM3 |  |  |  | ENNDBAPANA1 |  |  |  |  | 1 | 1 |  | 1 | 1 |  |  |  |  |  |  |  | 1 |  | 1 |  | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 |  |  | 1 | 11
ENNDANANDNGR1 | ENNDHANUMANG1 |  |  |  | ENNDBAPANA2 |  |  |  | 1 |  | 1 |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 |  |  |  |  | 1 |  | 7
ENNDANANDNGR1 | ENNDCHINARWAR2 |  |  |  | Grand Total | 2 | 2 | 2 | 1 | 1 | 3 | 2 | 1 | 1 | 2 | 1 | 2 | 1 | 1 | 2 | 1 | 1 | 1 | 2 | 1 | 2 | 3 | 3 | 2 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2 | 1 | 1 | 1 | 1 | 1 | 1 | 3 | 1 | 1 | 60
ENNDANANDNGR1 | ENNDIBSOGNHTL2
ENNDANANDNGR1 | ENNDVIPRD1
ENNDANANDNGR1 | ENNDIBSOROY4
ENNDANANDNGR1 | ENNDIBSOSHIVN3 |  |  |  | Look at the Row Labels, [NAME] to find only show Counts > 1
ENNDANANDNGR1 | ENNDIBSOSHIVN4 |  |  |  | Here is a Filtered Source only showing Counts greater than one
ENNDANANDNGR1 | ENNDIBSOROY1 |  |  |  | SOURCE | (All) |  |  | This table may show the number of calls a tower handled
ENNDANANDNGR2 | ENNDIBSOGNHTL3 |  |  |  |  |  |  |  | Row Labels | Count of SOURCE
ENNDANANDNGR2 | ENNDANANDNGR1 |  |  |  | Row Labels | Count of TARGET |  |  | ENNDANANDNGR1 | 15
ENNDANANDNGR2 | [NAME] |  |  |  | ENNDANANDNGR1 | 2 |  |  | ENNDANANDNGR2 | 13
ENNDANANDNGR2 | ENNDIBSOVASNT3 |  |  |  | ENNDANANDNGR2 | 2 |  |  | ENNDANANDNGR3 | 14
ENNDANANDNGR2 | ENNDHANUMANG3 |  |  |  | ENNDANANDNGR3 | 2 |  |  | ENNDBAPANA1 | 11
ENNDANANDNGR2 | ENNDIBSOGNHTL2 |  |  |  | ENNDBAPANA3 | 3 |  |  | ENNDBAPANA2 | 7
ENNDANANDNGR2 | ENNDIBSOANAND3 |  |  |  | ENNDCHINARWAR2 | 2 |  |  | Grand Total | 60
ENNDANANDNGR2 | ENNDANANDNGR3 |  |  |  | ENNDHANUMANG1 | 2
ENNDANANDNGR2 | ENNDBAPANA3 |  |  |  | ENNDHANUMANG3 | 2
ENNDANANDNGR2 | ENNDIBSOVASNT2 |  |  |  | ENNDIBSOANAND3 | 2
ENNDANANDNGR2 | ENNDHANUMANG1 |  |  |  | ENNDIBSODATTA3 | 2
ENNDANANDNGR2 | ENNDVIPRD1 |  |  |  | ENNDIBSOGNHTL1 | 2
ENNDANANDNGR2 | ENNDIBSOGNHTL1 |  |  |  | ENNDIBSOGNHTL2 | 3
ENNDANANDNGR3 | ENNDIBSOANAND2 |  |  |  | ENNDIBSOGNHTL3 | 3
ENNDANANDNGR3 | ENNDANANDNGR1 |  |  |  | ENNDIBSOGOPA2 | 2
ENNDANANDNGR3 | ENNDIBSOGOPA2 |  |  |  | ENNDIBSOVASNT2 | 2
ENNDANANDNGR3 | ENNDIBSOGNHTL3 |  |  |  | ENNDVIPRD1 | 3
ENNDANANDNGR3 | ENNDIBSOANAND3 |  |  |  | Grand Total | 34
ENNDANANDNGR3 | ENNDIBSOVASNT2
ENNDANANDNGR3 | ENNDCHINARWAR2
ENNDANANDNGR3 | ENNDANANDNGR2
ENNDANANDNGR3 | ENNDIBSOMANIK2
ENNDANANDNGR3 | ENNDVIPRD1
ENNDANANDNGR3 | ENNDRAJENDRA1
ENNDANANDNGR3 | ENNDIBSOANAND4
ENNDANANDNGR3 | [NAME]
ENNDANANDNGR3 | ENNDIBSOVASNT1
ENNDBAPANA1 | ENNDIBSOGNHTL2
ENNDBAPANA1 | [NAME]
ENNDBAPANA1 | ENNDBAPANA3
ENNDBAPANA1 | ENNDDEGLURNK3
ENNDBAPANA1 | ENNDIBSODATTA3
ENNDBAPANA1 | NRLYKAMTHA2
ENNDBAPANA1 | [NAME]
ENNDBAPANA1 | ENNDSAKTINGR1
ENNDBAPANA1 | ENNDDEGLURNK1
ENNDBAPANA1 | [NAME]
ENNDBAPANA1 | ENNDIBSOGNHTL1
ENNDBAPANA2 | ENNDIBSODATTA2
ENNDBAPANA2 | ENNDIBSODATTA3
ENNDBAPANA2 | ENNDVIPRD2
ENNDBAPANA2 | ENNDIBSOVSHU2
ENNDBAPANA2 | ENNDBAPANA1
ENNDBAPANA2 | ENNDIBSOYATR4
ENNDBAPANA2 | ENNDBAPANA3