Pivot Table
I have a pivot table pulling data from a table in a worksheet. I want to calculate the number of columns I have for each contact in the spreadsheet.
Example: See Attached
Julie Jones attended two events
Sum up the Yes for each contact.
Is there a way to do that in pivot table if the data is in different columns?
|