I need a small program to read an EXCEL file. A sample file is attached.
The rules are
If a row does not have a "DATE" in the first column, the description of that row will append to that in the previous row which has "DATE". If a row after that still does not have a "DATE", then append the description to the previous appended description until reach to a row which has "DATE". The withdraw, deposit and balance amount will be in the last row of that transaction.
A transaction sometimes is only displayed in one row, sometimes it will be displayed in multiple rows. I want a multiple row transactions being merged into one row.
Thanks.
Regards