I have two columns, one with German texts segments (in rows) and the second one with the Spanish translations of these segments. The problem is that in many cases the segments are too long for my purpose and therefore I inserted one or more <br> marks within the segments to split the segments at this/these places, obviously I inserted the same number of breaks in both columns (the German one and the Spanish one). I'd want now to insert automatically (I have over 5000 breaks!) new rows just below for each break.
Google Spreadsheets: Insert new rows automatically
google spreadsheets