i have a excel table with a lot of hire and termination transactions. Each line show a new transaction. I need to create a new table. It table will be to show only one line for each contract. On the new table i need to show Employee ID, Hire Date and Termination Date.