splitting multi line cells.

[tatrs]

Hi, I have the following spreadsheet http://i.imgur.com/D33BRcH.png
which I require reformatting from the first selection to the second. As you can see the second image the cells E1-E3 all have multiple lines which need to be split to look like cells E6-E14 in addition to cells A being duplicated into the created rows.

The sheet has a few thousand entries in so doing the by hand would take quite some time, any help would be appreciated.

Thank you.

[Lupp]

I cannot see anything corresponding to the text of the above question in the image. And: Please post relevant examples in odf files instead of images (with the one exception of explaing problems concerning a view)…