Hi, I have the example table below.  How do I create a pivot table that lists the tasks each Unit is responsible for?  I would like it to look like: 

Policy Unit

Task 1

Task 8

Task 9

Compliance Unit

Task 2

Task 3

Task 5

Task 7 etc…

Basically wondering how can I combine Unit and Unit2 to use in my pivot table.  Or how do I create a pivot table that would list tasks by each owner, John is responsible for Task 1, and 9. 

I am stuck when a task is completed by more than one Unit or person?

#TaskUnit Unit2Task Owners1Task 1PolicyOperationsJohn, Linda2Task 2OperationsComplianceLinda, Mary3Task 3Compliance Mary4Task 4Enforcement Lydia, Steve5Task 5Compliance Mary6Task 6Operations Linda7Task 7EnforcementComplianceLydia, Mary8Task 8EnforcementPolicyLydia9Task 9Policy John

​Hi, I have the example table below.  How do I create a pivot table that lists the tasks each Unit is responsible for?  I would like it to look like: Policy UnitTask 1Task 8Task 9Compliance UnitTask 2Task 3Task 5Task 7 etc… Basically wondering how can I combine Unit and Unit2 to use in my pivot table.  Or how do I create a pivot table that would list tasks by each owner, John is responsible for Task 1, and 9.  I am stuck when a task is completed by more than one Unit or person? #TaskUnit Unit2Task Owners1Task 1PolicyOperationsJohn, Linda2Task 2OperationsComplianceLinda, Mary3Task 3Compliance Mary4Task 4Enforcement Lydia, Steve5Task 5Compliance Mary6Task 6Operations Linda7Task 7EnforcementComplianceLydia, Mary8Task 8EnforcementPolicyLydia9Task 9Policy John  Read More

​