Pivot Table Issues

[CountedOut]

Hello,

I am trying to format this set of data into a pivot table and ultimately a pivot chart, showing each response with the corresponding manager and count of each response.

For some reason unknown to me I cannot get it to count each response separately.

Any ideas?

Timestamp

1. Team members are passionate and unguarded in the discussion of issues.

2. Team members call out one another's deficiencies or unproductive behaviors.

3. Team members know what their peers are working on and how they contribute to the collective good of the team.

4. Team members quickly and genuinely apologize to one another when they say or do something inappropriate or possibly damaging to the team.

5. Team members willingly make sacrifices (such as budget, turf, head count) in their departments or areas of expertise for the good of the team.

6. Team members openly admit their weaknesses and mistakes.

7. Team members are compelling, and not boring.

8. Team members leave meetings confident that their peers are completely committed to the decisions that were agreed on, even if there was initial disagreement.

9. Morale is significantly affected by the failure to achieve team goals.

10. During team meetings, the most important and difficult issues are put on the table to be resolved.

11. Team members are deeply concerned about the prospect of letting down their peers.

12. Team members know about one another's personal lives and are comfortable discussing them.

13. Team members end discussions with clear and specific resolutions and calls to action.

14. Team members challenge one another about their plans and approaches.

15. Team members are slow to seek credit for their own contributions, but quick to point out those of others.

Who is your manager?

2016/12/08 3:31:53 PM CST

3) Usually

3) Usually

3) Usually

3) Usually

3) Usually

3) Usually

3) Usually

3) Usually

3) Usually

3) Usually

3) Usually

2) Sometimes

3) Usually

2) Sometimes

3) Usually

John

2016/12/08 3:32:43 PM CST

3) Usually

3) Usually

2) Sometimes

2) Sometimes

2) Sometimes

3) Usually

3) Usually

3) Usually

2) Sometimes

3) Usually

3) Usually

2) Sometimes

3) Usually

3) Usually

3) Usually

John

2016/12/08 3:32:45 PM CST

3) Usually

2) Sometimes

3) Usually

2) Sometimes

3) Usually

3) Usually

3) Usually

3) Usually

3) Usually

3) Usually

3) Usually

2) Sometimes

3) Usually

3) Usually

3) Usually

John

2016/12/08 3:33:02 PM CST

3) Usually

2) Sometimes

3) Usually

3) Usually

1) Rarely

3) Usually

1) Rarely

3) Usually

2) Sometimes

3) Usually

2) Sometimes

2) Sometimes

3) Usually

2) Sometimes

3) Usually

John

2016/12/08 3:33:23 PM CST

3) Usually

2) Sometimes

3) Usually

3) Usually

3) Usually

3) Usually

3) Usually

3) Usually

2) Sometimes

3) Usually

1) Rarely

2) Sometimes

3) Usually

3) Usually

3) Usually

John

2016/12/08 3:33:48 PM CST

3) Usually

2) Sometimes

3) Usually

3) Usually

2) Sometimes

2) Sometimes

2) Sometimes

3) Usually

2) Sometimes

3) Usually

1) Rarely

1) Rarely

3) Usually

2) Sometimes

1) Rarely

John

2016/12/08 3:39:22 PM CST

2) Sometimes

1) Rarely

3) Usually

2) Sometimes

1) Rarely

1) Rarely

2) Sometimes

3) Usually

3) Usually

1) Rarely

2) Sometimes

1) Rarely

2) Sometimes

1) Rarely

1) Rarely

John

2016/12/08 3:42:28 PM CST

3) Usually

3) Usually

3) Usually

3) Usually

3) Usually

2) Sometimes

3) Usually

3) Usually

3) Usually

3) Usually

3) Usually

2) Sometimes

3) Usually

3) Usually

3) Usually

John

2016/12/08 3:48:44 PM CST

2) Sometimes

2) Sometimes

3) Usually

3) Usually

3) Usually

3) Usually

3) Usually

3) Usually

2) Sometimes

3) Usually

2) Sometimes

2) Sometimes

3) Usually

2) Sometimes

1) Rarely

John

2016/12/08 5:46:30 PM CST

2) Sometimes

2) Sometimes

3) Usually

2) Sometimes

2) Sometimes

2) Sometimes

3) Usually

3) Usually

2) Sometimes

3) Usually

2) Sometimes

2) Sometimes

3) Usually

2) Sometimes

2) Sometimes

John

2016/12/09 7:49:11 AM CST

3) Usually

2) Sometimes

3) Usually

3) Usually

3) Usually

3) Usually

2) Sometimes

3) Usually

2) Sometimes

3) Usually

3) Usually

2) Sometimes

3) Usually

2) Sometimes

3) Usually

John

2016/12/09 7:49:16 AM CST

3) Usually

3) Usually

3) Usually

3) Usually

3) Usually

3) Usually

3) Usually

3) Usually

1) Rarely

3) Usually

3) Usually

2) Sometimes

3) Usually

3) Usually

3) Usually

John

2016/12/09 7:50:02 AM CST

3) Usually

3) Usually

3) Usually

3) Usually

3) Usually

3) Usually

3) Usually

2) Sometimes

3) Usually

3) Usually

3) Usually

3) Usually

3) Usually

3) Usually

3) Usually

John

2016/12/12 10:26:54 AM CST

1) Rarely

1) Rarely

1) Rarely

2) Sometimes

2) Sometimes

1) Rarely

2) Sometimes

1) Rarely

1) Rarely

2) Sometimes

2) Sometimes

2) Sometimes

1) Rarely

1) Rarely

2) Sometimes

Jack

2016/12/12 11:54:22 AM CST

2) Sometimes

1) Rarely

3) Usually

3) Usually

2) Sometimes

2) Sometimes

1) Rarely

2) Sometimes

2) Sometimes

1) Rarely

3) Usually

3) Usually

2) Sometimes

3) Usually

2) Sometimes

Jack

2016/12/12 1:42:25 PM CST

2) Sometimes

1) Rarely

3) Usually

3) Usually

3) Usually

3) Usually

2) Sometimes

3) Usually

1) Rarely

3) Usually

3) Usually

1) Rarely

3) Usually

2) Sometimes

1) Rarely

Jack

2016/12/13 9:22:38 AM CST

3) Usually

2) Sometimes

3) Usually

2) Sometimes

2) Sometimes

2) Sometimes

3) Usually

2) Sometimes

3) Usually

2) Sometimes

3) Usually

2) Sometimes

2) Sometimes

3) Usually

3) Usually

Jack

2016/12/13 10:22:33 AM CST

1) Rarely

1) Rarely

1) Rarely

1) Rarely

1) Rarely

1) Rarely

2) Sometimes

2) Sometimes

2) Sometimes

1) Rarely

1) Rarely

2) Sometimes

1) Rarely

1) Rarely

1) Rarely

Jack

2016/12/13 10:22:43 AM CST

2) Sometimes

1) Rarely

2) Sometimes

1) Rarely

2) Sometimes

2) Sometimes

2) Sometimes

1) Rarely

1) Rarely

1) Rarely

1) Rarely

2) Sometimes

2) Sometimes

1) Rarely

2) Sometimes

Jack

2016/12/13 10:24:22 AM CST

1) Rarely

2) Sometimes

2) Sometimes

3) Usually

2) Sometimes

3) Usually

3) Usually

2) Sometimes

2) Sometimes

2) Sometimes

3) Usually

3) Usually

2) Sometimes

3) Usually

2) Sometimes

Jack

2016/12/13 10:24:56 AM CST

2) Sometimes

1) Rarely

1) Rarely

1) Rarely

3) Usually

1) Rarely

3) Usually

2) Sometimes

2) Sometimes

2) Sometimes

1) Rarely

2) Sometimes

2) Sometimes

2) Sometimes

1) Rarely

Jack

2016/12/13 10:29:39 AM CST

1) Rarely

2) Sometimes

2) Sometimes

2) Sometimes

2) Sometimes

1) Rarely

2) Sometimes

1) Rarely

1) Rarely

2) Sometimes

1) Rarely

2) Sometimes

2) Sometimes

1) Rarely

2) Sometimes

Jack

2016/12/13 10:33:54 AM CST

1) Rarely

2) Sometimes

2) Sometimes

1) Rarely

2) Sometimes

3) Usually

2) Sometimes

1) Rarely

1) Rarely

1) Rarely

1) Rarely

2) Sometimes

2) Sometimes

1) Rarely

2) Sometimes

Jack

2016/12/13 10:35:58 AM CST

2) Sometimes

1) Rarely

2) Sometimes

1) Rarely

2) Sometimes

2) Sometimes

1) Rarely

1) Rarely

3) Usually

2) Sometimes

2) Sometimes

2) Sometimes

2) Sometimes

2) Sometimes

2) Sometimes

Jack

2016/12/13 11:08:45 AM CST

2) Sometimes

2) Sometimes

2) Sometimes

2) Sometimes

1) Rarely

3) Usually

2) Sometimes

2) Sometimes

2) Sometimes

2) Sometimes

2) Sometimes

2) Sometimes

2) Sometimes

3) Usually

2) Sometimes

Jack

2016/12/13 11:12:13 AM CST

3) Usually

3) Usually

3) Usually

3) Usually

3) Usually

3) Usually

3) Usually

3) Usually

1) Rarely

3) Usually

3) Usually

2) Sometimes

3) Usually

3) Usually

3) Usually

Jill

2016/12/13 11:13:13 AM CST

3) Usually

2) Sometimes

3) Usually

3) Usually

2) Sometimes

3) Usually

3) Usually

3) Usually

2) Sometimes

2) Sometimes

3) Usually

2) Sometimes

3) Usually

3) Usually

2) Sometimes

Jill

2016/12/13 11:14:12 AM CST

3) Usually

3) Usually

3) Usually

3) Usually

2) Sometimes

3) Usually

3) Usually

2) Sometimes

2) Sometimes

3) Usually

2) Sometimes

2) Sometimes

2) Sometimes

3) Usually

3) Usually

Jill

2016/12/08 3:49:16 PM CST

3) Usually

2) Sometimes

3) Usually

2) Sometimes

3) Usually

3) Usually

3) Usually

3) Usually

3) Usually

3) Usually

3) Usually

3) Usually

3) Usually

3) Usually

3) Usually

Will

2016/12/08 3:50:47 PM CST

3) Usually

2) Sometimes

3) Usually

3) Usually

3) Usually

3) Usually

3) Usually

3) Usually

1) Rarely

3) Usually

1) Rarely

3) Usually

3) Usually

3) Usually

1) Rarely

Will

2016/12/08 3:51:21 PM CST

2) Sometimes

1) Rarely

3) Usually

3) Usually

3) Usually

3) Usually

3) Usually

3) Usually

3) Usually

3) Usually

2) Sometimes

3) Usually

3) Usually

3) Usually

2) Sometimes

Will

2016/12/08 3:52:52 PM CST

2) Sometimes

2) Sometimes

3) Usually

3) Usually

3) Usually

2) Sometimes

2) Sometimes

2) Sometimes

2) Sometimes

3) Usually

3) Usually

1) Rarely

3) Usually

2) Sometimes

2) Sometimes

Will

2016/12/08 3:54:33 PM CST

3) Usually

1) Rarely

3) Usually

3) Usually

3) Usually

3) Usually

3) Usually

2) Sometimes

3) Usually

2) Sometimes

1) Rarely

3) Usually

2) Sometimes

3) Usually

3) Usually

Will

2016/12/08 8:19:04 PM CST

3) Usually

2) Sometimes

3) Usually

2) Sometimes

3) Usually

3) Usually

3) Usually

3) Usually

2) Sometimes

3) Usually

3) Usually

3) Usually

3) Usually

3) Usually

3) Usually

Will

2016/12/09 7:51:18 AM CST

2) Sometimes

1) Rarely

2) Sometimes

3) Usually

2) Sometimes

2) Sometimes

3) Usually

2) Sometimes

2) Sometimes

2) Sometimes

1) Rarely

3) Usually

2) Sometimes

1) Rarely

2) Sometimes

Will

2016/12/09 8:08:30 AM CST

2) Sometimes

1) Rarely

3) Usually

2) Sometimes

2) Sometimes

3) Usually

2) Sometimes

3) Usually

2) Sometimes

3) Usually

2) Sometimes

2) Sometimes

3) Usually

2) Sometimes

2) Sometimes

Will

2016/12/09 9:05:38 AM CST

3) Usually

1) Rarely

2) Sometimes

3) Usually

2) Sometimes

3) Usually

3) Usually

3) Usually

3) Usually

3) Usually

3) Usually

3) Usually

3) Usually

3) Usually

2) Sometimes

Will

2016/12/09 9:38:12 AM CST

3) Usually

2) Sometimes

3) Usually

3) Usually

3) Usually

3) Usually

3) Usually

3) Usually

3) Usually

3) Usually

2) Sometimes

2) Sometimes

3) Usually

3) Usually

2) Sometimes

Will

2016/12/09 9:38:27 AM CST

3) Usually

3) Usually

3) Usually

2) Sometimes

3) Usually

3) Usually

3) Usually

2) Sometimes

1) Rarely

3) Usually

2) Sometimes

3) Usually

2) Sometimes

3) Usually

3) Usually

Will

2016/12/09 9:40:43 AM CST

3) Usually

2) Sometimes

3) Usually

3) Usually

3) Usually

2) Sometimes

3) Usually

2) Sometimes

3) Usually

2) Sometimes

2) Sometimes

2) Sometimes

3) Usually

3) Usually

3) Usually

Will

2016/12/09 9:41:00 AM CST

3) Usually

3) Usually

2) Sometimes

3) Usually

2) Sometimes

2) Sometimes

3) Usually

3) Usually

2) Sometimes

3) Usually

2) Sometimes

2) Sometimes

3) Usually

3) Usually

3) Usually

Will

2016/12/09 9:46:18 AM CST

3) Usually

3) Usually

3) Usually

3) Usually

3) Usually

3) Usually

3) Usually

3) Usually

2) Sometimes

3) Usually

3) Usually

3) Usually

3) Usually

3) Usually

3) Usually

Will

2016/12/09 9:54:56 AM CST

3) Usually

1) Rarely

3) Usually

3) Usually

3) Usually

3) Usually

3) Usually

3) Usually

3) Usually

3) Usually

2) Sometimes

1) Rarely

3) Usually

3) Usually

3) Usually

Will

<colgroup><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>

 

[KenDue]

If I understand your problem correctly, you wish to find out the total sum of each response for each manager. You first need to count the number of responses on each row for each answer.

In row 1, col R, type Answer1. In col S, type Answer2. In col T, type Answer3.

In R2, type formula: =COUNTIF($B2:$Q2,"1*")
In S2, type formula: =COUNTIF($B2:$Q2,"2*")
In T2, type formula: =COUNTIF($B2:$Q2,"3*")

Copy these down to bottom of your list of answers.

Now, when you produce your Pivot Table, you can show the total of each answer for each manager using SUM instead of COUNT in your list of Values for each answer.