Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

splitting multi line cells.

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.