privot table help
 

If i have info in the form of this:

date total date reg date irreg
06/06/08 1.50 06/06/08 1.50 07/06/08 4.50
07/06/08 4.50 09/06/08 4.50 09/06/08 8.00
09/06/08 12.50 10/06/08 8.00 13/06/08 3.50
10/06/08 8.00 11/06/08 4.50 15/06/08 10.75
11/06/08 4.50 13/06/08 2.00 16/06/08 8.00
13/06/08 5.50 19/06/08 8.00 19/06/08 11.00
15/06/08 10.75
16/06/08 8.00
19/06/08 19.00


How do i put this into 1 pivot table so i get:
date total reg irreg
xxx xx xx xx
xxx xx xx xx