How can I create a pivot table for each row to summarise each category to do a count of each unique entry as a pie chart? Here is a sample of what each row and column looks like.
A
B
C
D
E
F
G
H
I
J
K
L
M
1
Timestamp
Email Address
Name
Date & TIme
City, Country
Question 1
Category 1...