Hi Excel Experts,

I have data which are exported from Sharepoint List to excel in the
following format:

NAME BRANDS
Adam Sandler Marlboro;#Dunhill;#Salem
Tim Duncan Marlboro
Sally Sue Salem
Briana Matt Marlboro;#Dunhill

How can I use pivot table to display the following the following
results:

NAME BRANDS TOTAL
Marlboro Dunhill Salem
Adam Sandler 1 1 1 3
Tim Duncan 1 1
Sally Sue 1 1
Briana Matt 1 1 2
TOTAL 3 2 2 7

Any help or suggestions would be deeply appreciated. Thanks.