Multi-line excel cells into rows

Hi,

I have three columns which contain multi-line cells, i.e. text separated by ALT+ENTER. Lines of these cells are grouped with each other, i.e. line 1 in cell A2 match with line 1 in B2 and C2. Then I have columns from onwards which have info in the first line which is attributable to all lines in the specific row.

I now want to turn these multi-line cells from columns A to C to multiple rows and copy the data of columns D to onwards to every new row.

Hopefully my explanation was not too complicated.

-Valt