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
<colgroup><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>
Employee ID | First Name | Last Name | Full Name | Bonus plan | Vest Date | Payout Amount USD |
123 | Jane | Doe | Jane Doe | LTI | 1-Jan-17 | 4000 |
123 | Jane | Doe | Jane Doe | LTI | 1-jan 208 | 500 |
123 | Jane | Doe | Jane Doe | LTI | 1-Jan-19 | 730000 |
568 | John | Doe | John Doe | RTI | 1-Jan-17 | 8000 |
568 | John | Doe | John Doe | LTI | 2-Mar-19 | 2400 |
<colgroup><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>