i have a list of suppliers and the departments to which they have supplied goods and services. I am trying to look at my list to see which suppliers have supplied to all departments. have started with a pivot table suppliers in the rows and departments across the top (columns). Is there any way to just have a 1 under each of the departments supplied. there are six departments, if a supplier was active with each, there would be a one under each department name in the pivot table. this is the type of result i want to achieve. Can it be done?
| Dept A | Dept B | Dept C | Dept D | Dept E | Dept F | |
| Coy 1 | 1 | 1 | 1 | |||
| Coy 2 | 1 | 1 | ||||
| Coy 3 | 1 | |||||
| Coy 4 | 1 | 1 | ||||
| Coy 5 | 1 | 1 | 1 | 1 | 1 | 1 |
| Coy 6 | 1 | 1 |
