Display data by date in Pivot

[ashishprem]

Hi,

I have a data in the sheet like displayed below

Name date Records elapse
m1 10-Mar-08 500 10
m1 11-Mar-08 200 20
m2 10-Mar-08 100 25

I want to display in a more organised way like below

10-Mar-08 11-Mar-08
Records Elapsed Records Elapsed
m1 500 10 200 20
m2 100 25

I am trying to do in pivot table but I am unable.

Any suggestion to get this done will be highly appreciated.

Ashish

[Portuga]

Hi

Put Name in the Row section
Put date in the column section

Put the remaining 2 in the data section.

right click on the "Data" cell. Choose "sort by column"