Well KiXtart is not exactly a match for doing this sort of manipulation of Excel data. I would recommend using the built-in VBA or if you're not familiar with it then this site here is like KiXtart.org only for EXCEL

There are a lot of very smart guys over there that can easily help you whip up something.

http://www.mrexcel.com/