Hi,

I'm relatively new to pivot tables so I'm not sure if I'm explaining this correctly, so bear with me.

I have a table which is been pulled from an external source, so I can't manipulate the source content.

My problem is that one of the fields that is been dragged down, can have one or more options in it. For Example:

Country
US
US;UK
US;UK; France

I want to split these up in a pivot table so that I would be able to count the number of times each country appears, so:
US 3
UK 2
France 1

and then display them in my chart.

Does anyone know if this is possible?

Thanks in advance.