Hi, I have been working on this for more than 4 hours and reviewed so many formulas online. I need to create a mail merger with multiple rows. Here is the sample data, I have more than 700 individual employees on the sheet. I need to show on one page per employee all the applicable Bonus plan, their respective vesting date and amount paid. I am very confused with "Key", if someone can help me what i can plug(copy/paste) to make this work in template. I have the mail merge set up as directory. thank you very much
[TABLE="width: 584"]
<colgroup><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]Employee ID[/TD]
[TD]First Name[/TD]
[TD]Last Name[/TD]
[TD]Full Name[/TD]
[TD]Bonus plan[/TD]
[TD]Vest Date[/TD]
[TD]Payout Amount USD[/TD]
[/TR]
[TR]
[TD="align: right"]123[/TD]
[TD]Jane[/TD]
[TD]Doe[/TD]
[TD]Jane Doe[/TD]
[TD]LTI[/TD]
[TD="align: right"]1-Jan-17[/TD]
[TD="align: right"]4000[/TD]
[/TR]
[TR]
[TD="align: right"]123[/TD]
[TD]Jane[/TD]
[TD]Doe[/TD]
[TD]Jane Doe[/TD]
[TD]LTI[/TD]
[TD]1-jan 208[/TD]
[TD="align: right"]500[/TD]
[/TR]
[TR]
[TD="align: right"]123[/TD]
[TD]Jane[/TD]
[TD]Doe[/TD]
[TD]Jane Doe[/TD]
[TD]LTI[/TD]
[TD="align: right"]1-Jan-19[/TD]
[TD="align: right"]730000[/TD]
[/TR]
[TR]
[TD="align: right"]568[/TD]
[TD]John[/TD]
[TD]Doe[/TD]
[TD]John Doe[/TD]
[TD]RTI[/TD]
[TD="align: right"]1-Jan-17[/TD]
[TD="align: right"]8000[/TD]
[/TR]
[TR]
[TD="align: right"]568[/TD]
[TD]John[/TD]
[TD]Doe[/TD]
[TD]John Doe[/TD]
[TD]LTI[/TD]
[TD="align: right"]2-Mar-19[/TD]
[TD="align: right"]2400[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 584"]
<colgroup><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]Employee ID[/TD]
[TD]First Name[/TD]
[TD]Last Name[/TD]
[TD]Full Name[/TD]
[TD]Bonus plan[/TD]
[TD]Vest Date[/TD]
[TD]Payout Amount USD[/TD]
[/TR]
[TR]
[TD="align: right"]123[/TD]
[TD]Jane[/TD]
[TD]Doe[/TD]
[TD]Jane Doe[/TD]
[TD]LTI[/TD]
[TD="align: right"]1-Jan-17[/TD]
[TD="align: right"]4000[/TD]
[/TR]
[TR]
[TD="align: right"]123[/TD]
[TD]Jane[/TD]
[TD]Doe[/TD]
[TD]Jane Doe[/TD]
[TD]LTI[/TD]
[TD]1-jan 208[/TD]
[TD="align: right"]500[/TD]
[/TR]
[TR]
[TD="align: right"]123[/TD]
[TD]Jane[/TD]
[TD]Doe[/TD]
[TD]Jane Doe[/TD]
[TD]LTI[/TD]
[TD="align: right"]1-Jan-19[/TD]
[TD="align: right"]730000[/TD]
[/TR]
[TR]
[TD="align: right"]568[/TD]
[TD]John[/TD]
[TD]Doe[/TD]
[TD]John Doe[/TD]
[TD]RTI[/TD]
[TD="align: right"]1-Jan-17[/TD]
[TD="align: right"]8000[/TD]
[/TR]
[TR]
[TD="align: right"]568[/TD]
[TD]John[/TD]
[TD]Doe[/TD]
[TD]John Doe[/TD]
[TD]LTI[/TD]
[TD="align: right"]2-Mar-19[/TD]
[TD="align: right"]2400[/TD]
[/TR]
</tbody>[/TABLE]