Hi,

Hope you can help me! I have a spreadsheet with multiple identical columns that contain lists of interventions that employees do with clients (I.e., Intervention 1, Intervention 2, Intervention 3, etc). Each Intervention column contains the same list of 20 interventions. I can use the COUNTIF function to determine the number of specific interventions across these columns; however, I want to filter this by employee. Is there a way to collapse across these columns in a pivot table? Any advice would be greatly appreciated.

C