1.

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

Answer»

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 advanceHomework?Yes,

i am having community service on organizing activities for children.


Discussion

No Comment Found

Related InterviewSolutions