importing data from text file

Dear experts,

I need to import a similar text file as given in the sample here, with the following specifications:
1.in the line #BEGIN abc 1, the no.( 1 in this case)should be in the column 1 of row 1. every time the term #BEGIN appears, data should be imported to a new row.
2.for all other data below this line, the data below the line beginning with # should be taken into the row/cell ( i.e., blah blah blah in #Name:
blah blah blah).
Here's how I need it sample.xlsx.