Pivot Table nightmare

[hannahmc8]

HI,
I am relatively new to the joy of Pivot Tables. I have created this one from data I have but now need to extract into 7 cells the Petty cash gross amount from till 1 on every day from the 30th May to the 5th June. Then till 2..., till 3... As you can see there are no Petty cash purchases on some of the days. Please help, thank you in advance, (The data is example data at the moment and not accurate - VAT!!!)
Hannah

TILL
NUMBER...DATE.................PETTY CASH NET..........VAT................PETTY CASH GROSS
1.............05-Jun-11...........400............................20.................420
2.............31-May-11..........30............................. 20.................50
3.............01-Jun-11...........200........................... 20.................220
..............05-Jun-11............90.............................20.................110
4.............05-Jun-11...........200............................20.................220

 

[Robert Mika]

Is that the data from the pivot or the actuall data from which you have created the pivot?

 

[hannahmc8]

Hi that's the data from the pivot.