I'll appreciate any assistance on this. The scenario;

I have a database table with the following sample records;

Code:
data1-------------dt2----data3------data4--------data5------data6
Brewing Plant-----2------10000------11/3/2012----1136-------person1@yahoo.com
Brewing Plant-----2------10000------11/3/2012----1136-------person1@yahoo.com
Car Plant---------1------5000-------11/3/2012----568--------person1@yahoo.com
...