splitting multi line cells.

asked 2017-04-09 21:48:06 +0100

tatrs gravatar image

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.

edit retag flag offensive close merge delete

Comments

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)..

Lupp gravatar imageLupp ( 2017-04-10 00:19:06 +0100 )edit