logic like Pivote Table for Report

hi,

I have followin fields in my internal table

Location Tranfer Structure Date Size

INDIA /BIC/TS3 03.07.2005 130

NW /BIC/TS3 03.07.2005 30

NW /BIC/TS2 02.07.2005 20

NW /BIC/TS1 01.07.2005 110

UK /BIC/TS3 03.07.2005 20

UK /BIC/TS2 02.07.2005 20

UK /BIC/TS1 01.07.2005 10

And i want to print like

Location T.S 01.07.2005 02.07.2005 03.07.2005

INDIA /BIC/TS3 130

NW /BIC/TS1 110

/BIC/TS2 20

/BIC/TS3 30

UK /BIC/TS1 10

/BIC/TS2 20

/BIC/TS3 20

Can any 1 help me out for this ?

Also How to how to export data into Excel??

Thanks

cool