I have a record from which I need to create a hierarchical recordset to export to Excel. The format of the record is as follows: Product, Date1, AddAmount1, DeductAmount1, Date2, AddAmount2, DeductAmount2, Date3, AddAmount3, DeductAmount3... and so on. I want the record displayed in Excel as: Product Date Date2 Date3 AddAmount1 AddAmount2 AddAmount3 DeductAmount1 DeductAmount2 DeductAmount3 I am open to how this might be accomplished, and the Excel portion isn't necessary as long as a recordset is created that I can dump into Excel.
## Deliverables
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request. 3) Complete ownership and distribution copyrights to all work purchased.
## Platform
VB.NET
## Deadline information
Must be in VB.NET form ready to debug.