Merge irregular rows data into 1 column and find the next row based on another column

We had downloaded a file and had exported it into EXCEL.

We need to merge the data in different rows for sorting and calculation purpose.

The cell to identify each set of data is in Column H (Nature of Claim). Some set of data have 10 rows and some have 7 rows.

I had attached a file with the desired result in another worksheet. After merging the rows, I need to display the merge data as a separate line (wrap text) as if it's in different rows but actually data are in 1 cell.

Need to find out the amount by identifying the wordings "SIN" and "SGD" OR just a "-" in column E.

Original file have thousand of rows and we are unable to sort by date and also to abstract the amount out.

Hoped someone can help.

This is a formula based proposal with a lot of helper columns:
1. Columns I:O are populated using: =IF(AND($B13<>"",OR($B12="",ROW()=13)),B13,IF(B13<>"",I12&B13,I12))
2. Columns P is populated using: =AND(B13="",B14<>"")
The results:
1. Columns R:X are populated using: =IFERROR(INDEX(I$13:I$86,AGGREGATE(15,6,(ROW(I$13:I$86)-ROW(I$12))/($P$13:$P$86=TRUE),ROWS(R$13:R13))),"")
2. Column Y (the amount) is populated using: =IF(R13="","",SUMIFS(E$13:E$86,I$13:I$86,R13))
Let us know if you have any questions.

ec4excel... Please confirm the Excel product you are using and update your profile, if required.