Organise cells with line break into separate rows

[vjvj123]

Hi all,



I need help with a typical issue concerning tables. I have a table with (say) 10 columns (C1-C10) and 15 Rows (R1-R15). Most rows have one entry in each cell across the 10 columns. However, in C7 and C8, in some of the rows (say R5, R9 etc) the cells have multiple entries separated by a line break (I can find the line break by using ctrl+J in the find dialog box).
As an example the cell R5C7 contains 3 entries separated by line breaks, and the corresponding adjacent cell R5C8 also contains same number of entries (i.e. 3) separated by line breaks. I attach a sample file as an example, where the text under consideration is marked red for easy identification for this forum. Similarly, R9C7 and R9C8 contain multiple (two in this case) entries each. Multiple entries may be two, three, four or more in other C7 and C8 cells (although entries in a particular C7 cell=entries in the corresponding(adjacent) C8 cell).

Now, I wish to organise the data so that these multiple entries become separate rows of the table. The other remaining cells data (i.e. cells except C7 and C8) of these rows will be replicated. As shown in the attached sample file, below the original data, there is "Desired Data", the format in which I need the data.

Any help would be much appreciated, thanks for reading through the post.

Sorry for posting Excel file here, but since I can copy the table from excel to word and vice versa, any solution to this problem w.r.t MS Word will be appreciated as well.