Hi sshanku1985 and welcome to the forum.
We need a sample xls file with your data to understand it a bit better.
You can attach a sample workbook by clicking on "Go Advanced" under the message area and then on the Paper Clip Icon above the message. This will open a dialog box to attach your sample file. You problem doesn't seem that hard but typing in the data is a pain.