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 |