yes the table you created is correct....

i want to display 2 columns in the o/p IT,Marketing

1.

IT

darshan

lime

rats

sudarshan

2.

Marketing

rathan

shan

sharath

in the table you created dived the persons base on the department they belong to..

and sorry for capitals.