Help : Excel 2010: pivot table with text to search in multiple colons

[ER Ru]

Hi,

I am stuck in an issue to create a pivot table with text found n multiple colons:
 please see the issue here:
Name   Fisrt name   ACTIVITY 1   ACTIVITY 2   ACTIVITY 3
dupont   Pierre               Tennis               Danse           Ping pong
durant   Jean                       Danse      
nom 1   Marcel                Ping pong       Tennis   
nom 2   Francois                Judo      
nom3   Marine                Tennis      
martin   Tanguy                Danse              Tennis   


I need to create a list of names playing tennis

Thanks in advance

[DaveLembke]

Homework?

[ER Ru]

Yes,

i am having community service on organizing activities for children.