Pivot table

This query is : Open

Querist : Anonymous

Querist : Anonymous (Querist)

17 September 2012 Can we make pivot table of foll eg:

Date X Y z

1/8/12 Mum Delhi Pune
2/8/12 Delhi Mum Mum
3/8/12 Pune Pune Delhi

Can we know who was there at which location...
i have huge data...this is just part of it..

CA.Vinita Gupta

CA.Vinita Gupta (Expert)
Follow

17 September 2012 Yes u can make it

Querist : Anonymous

Querist : Anonymous (Querist)

17 September 2012 but how....that is my query!!

Upgrade to CAclubindia Pro. Subscribe Now!

CA.Vinita Gupta

CA.Vinita Gupta (Expert)
Follow

17 September 2012 I do not have the full data so its difficult to guide but i can tell u the steps:

Open the Excel Sheet:

Click Insert> Pivot Table> Select the Table Range>ok>

Pivot table will appear on the Sheet
then Select Pivot Table Field List

and do Permutations and Combintaions

Querist : Anonymous

Querist : Anonymous (Querist)

17 September 2012 u can guide me how to make it from the data given above....1st column is date...x,y and z (3 columns) are names of persons visited places....i want to know how many times x visited mumbai, pune and delhi...my data is same except huge number of people...