For example,
Line 1: 023 Description
Line 2: sentence 1
Line 3: sentence 2
Line 4: definition
Line 5: 0267 Description
Line 6: sentence 3
Line 7: sentence 4
Line 8: definition 2
Basically I want to output anything between the description and definition into an individual cell (i.e. sentence 1 & 2), then into the cell below it (sentence 3 & 4), and so on.
The problem is there are over a 1000 lines like this, so I want to develop a code which does this automatically for me.
Any ideas would be greatly appreciated.
Cheers.
Bookmarks