Hello, I'm new here.

I have text file, which have data blocks, 5-8 rows of data, values in lines are separated as a single space. Between blocks are one blank line feed. Block's length is 5-8 rows, depending of certain varible, which is located fourth row and twentieth value. So it is inside of block.. Text file looks like this:

[1# data block, 5-8 rows]

[2# data block, 5-8 rows]

[3# data block, 5-8 rows]

......

I want to import data blocks to cleartext, like this:

[1# data block, 5-8 rows]
field1=
field2=
field3=
..........

[2# data block, 5-8 rows]
field1=
field2=
field3=
..........

And so on.. Please help me, probably Excel is not the best tool to do this, but I have to use it. Can anyone help step-by-step ? I can extract data values to cleartext, but importing text file to excel as above is difficult..