Spreadsheet: 36887d1234862544-pivot-table-show-empty-rows-copy-of-demo
Sheet: Blad1

 |  |  |  |  |  |  |  |  | Subject | AA
Name | Number | City | Type | Subject | Method | Class | Combination |  | Aantal van Class | Type | Class
[NAME] | 1 | Amsterdam | LWOO | AA | [NAME] |  | [NAME] |  |  | LWOO |  |  | BGGT |  |  | KMBG
[NAME] | 1 | Amsterdam | LWOO | BO | Book | 1 | [NAME] |  | Combination | 1 | 2 | 3 | 1 | 2 | 3 | 1 | 2 | 3
[NAME] | 1 | Amsterdam | LWOO | UT | Pencil | 2 | [NAME] |  | [NAME] | 1 |  |  |  |  |  | 1
[NAME] | 1 | Amsterdam | LWOO | WB | [NAME] | 3 | [NAME] |  | [NAME]
[NAME] | 1 | Amsterdam | LWOO | CP | Computer |  | [NAME] |  | [NAME] | 1 |  |  | 1 |  |  |  |  | 1
[NAME] | 2 | [NAME] | LWOO | AA | [NAME] | 1 | [NAME] |  | [NAME] | 1 |  |  |  | 1 |  | 1
[NAME] | 2 | [NAME] | LWOO | BO | Book |  | [NAME]
[NAME] | 2 | [NAME] | LWOO | UT | Pencil | 2 | [NAME]
[NAME] | 2 | [NAME] | LWOO | WB | [NAME] | 3 | [NAME]
[NAME] | 2 | [NAME] | LWOO | CP | Computer | 2 | [NAME]
[NAME] | 3 | [NAME] | LWOO | AA | [NAME] | 1 | [NAME]
[NAME] | 3 | [NAME] | LWOO | bo | Book |  | [NAME]
[NAME] | 3 | [NAME] | LWOO | UT | Pencil | 2 | [NAME]
[NAME] | 3 | [NAME] | LWOO | WB | [NAME] | 3 | [NAME]
[NAME] | 3 | [NAME] | LWOO | CP | Computer |  | [NAME]
George | 4 | Groningen | LWOO | AA | [NAME] | 1 | [NAME]
George | 4 | Groningen | LWOO | bo | Book |  | [NAME]
George | 4 | Groningen | LWOO | UT | Pencil | 2 | [NAME]
George | 4 | Groningen | LWOO | WB | [NAME] | 3 | [NAME]
George | 4 | Groningen | LWOO | CP | Computer |  | [NAME]
[NAME] | 1 | Amsterdam | BGGT | AA | [NAME] |  | [NAME]
[NAME] | 1 | Amsterdam | BGGT | BO | Book | 3 | [NAME]
[NAME] | 1 | Amsterdam | BGGT | UT | Pencil | 1 | [NAME]
[NAME] | 1 | Amsterdam | BGGT | WB | [NAME] |  | [NAME] |  | Subject AA has only 3 out of 4 possible names
[NAME] | 1 | Amsterdam | BGGT | CP | Computer | 2 | [NAME] |  | My goal is to see all 4 names because these are possible prospects
[NAME] | 2 | [NAME] | BGGT | AA | [NAME] | 1 | [NAME]
[NAME] | 2 | [NAME] | BGGT | BO | Book | 1 | [NAME]
[NAME] | 2 | [NAME] | BGGT | UT | Pencil |  | [NAME] |  | This works for Type and Class
[NAME] | 2 | [NAME] | BGGT | WB | [NAME] | 3 | [NAME] |  | Here I choose the setting to show "items without numbers"
[NAME] | 2 | [NAME] | BGGT | CP | Computer | 3 | [NAME] |  | When I do the same for the rowheadings it doesn't give me the result I want
[NAME] | 3 | [NAME] | BGGT | AA | [NAME] | 2 | [NAME]
[NAME] | 3 | [NAME] | BGGT | bo | Book | 1 | [NAME]
[NAME] | 3 | [NAME] | BGGT | UT | Pencil | 1 | [NAME]
[NAME] | 3 | [NAME] | BGGT | WB | [NAME] | 2 | [NAME]
[NAME] | 3 | [NAME] | BGGT | CP | Computer | 3 | [NAME]
George | 4 | Groningen | BGGT | AA | [NAME] |  | [NAME]
George | 4 | Groningen | BGGT | bo | Book | 3 | [NAME]
George | 4 | Groningen | BGGT | UT | Pencil | 2 | [NAME]
George | 4 | Groningen | BGGT | WB | [NAME] | 1 | [NAME]
George | 4 | Groningen | BGGT | CP | Computer | 1 | [NAME]
[NAME] | 1 | Amsterdam | KMBG | AA | [NAME] |  | [NAME]
[NAME] | 1 | Amsterdam | KMBG | BO | Book | 3 | [NAME]
[NAME] | 1 | Amsterdam | KMBG | UT | Pencil |  | [NAME]
[NAME] | 1 | Amsterdam | KMBG | WB | [NAME] | 1 | [NAME]
[NAME] | 1 | Amsterdam | KMBG | CP | Computer | 2 | [NAME]
[NAME] | 2 | [NAME] | KMBG | AA | [NAME] | 3 | [NAME]
[NAME] | 2 | [NAME] | KMBG | BO | Book | 2 | [NAME]
[NAME] | 2 | [NAME] | KMBG | UT | Pencil | 1 | [NAME]
[NAME] | 2 | [NAME] | KMBG | WB | [NAME] | 3 | [NAME]
[NAME] | 2 | [NAME] | KMBG | CP | Computer | 2 | [NAME]
[NAME] | 3 | [NAME] | KMBG | AA | [NAME] | 1 | [NAME]
[NAME] | 3 | [NAME] | KMBG | bo | Book |  | [NAME]
[NAME] | 3 | [NAME] | KMBG | UT | Pencil | 2 | [NAME]
[NAME] | 3 | [NAME] | KMBG | WB | [NAME] | 3 | [NAME]
[NAME] | 3 | [NAME] | KMBG | CP | Computer |  | [NAME]
George | 4 | Groningen | KMBG | AA | [NAME] | 1 | [NAME]
George | 4 | Groningen | KMBG | bo | Book |  | [NAME]
George | 4 | Groningen | KMBG | UT | Pencil | 2 | [NAME]
George | 4 | Groningen | KMBG | WB | [NAME] | 3 | [NAME]
George | 4 | Groningen | KMBG | CP | Computer |  | [NAME]