How can I create multiple rows when there are multiple data points for the same attribute? Thanks!!!
For example, if there are 3 investors in company ABC, then there will be 3 rows
[FONT="]
-------------------------------------------------------------------------
[/FONT][TABLE="width: 548"]
<colgroup><col><col span="3"></colgroup><tbody>[TR]
[TD]From:[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Company[/TD]
[TD]Investor_1[/TD]
[TD]Investor_2[/TD]
[TD]Investor_3[/TD]
[/TR]
[TR]
[TD]ABC[/TD]
[TD]X[/TD]
[TD]Y[/TD]
[TD]Z[/TD]
[/TR]
[TR]
[TD]DEF[/TD]
[TD]U[/TD]
[TD]X[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]……[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]To:[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Deal_ID[/TD]
[TD]Company[/TD]
[TD]Investors[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]ABC_X[/TD]
[TD]ABC[/TD]
[TD]X[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]ABC_Y[/TD]
[TD]ABC[/TD]
[TD]Y[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]ABC_Z[/TD]
[TD]ABC[/TD]
[TD]Z[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]DEF_U[/TD]
[TD]DEF[/TD]
[TD]U[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]DEF_X[/TD]
[TD]DEF[/TD]
[TD]X[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]……[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
</tbody>[/TABLE]
For example, if there are 3 investors in company ABC, then there will be 3 rows
[FONT="]
-------------------------------------------------------------------------
[/FONT][TABLE="width: 548"]
<colgroup><col><col span="3"></colgroup><tbody>[TR]
[TD]From:[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Company[/TD]
[TD]Investor_1[/TD]
[TD]Investor_2[/TD]
[TD]Investor_3[/TD]
[/TR]
[TR]
[TD]ABC[/TD]
[TD]X[/TD]
[TD]Y[/TD]
[TD]Z[/TD]
[/TR]
[TR]
[TD]DEF[/TD]
[TD]U[/TD]
[TD]X[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]……[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]To:[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Deal_ID[/TD]
[TD]Company[/TD]
[TD]Investors[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]ABC_X[/TD]
[TD]ABC[/TD]
[TD]X[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]ABC_Y[/TD]
[TD]ABC[/TD]
[TD]Y[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]ABC_Z[/TD]
[TD]ABC[/TD]
[TD]Z[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]DEF_U[/TD]
[TD]DEF[/TD]
[TD]U[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]DEF_X[/TD]
[TD]DEF[/TD]
[TD]X[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]……[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
</tbody>[/TABLE]