<tbody>
Employee
Rate
Effective Date
Brandon
$15.00
1/1/17
Anthony
$12.50
1/1/17
James
$17.00
1/1/17
Josh
$16.50
1/1/17
Brandon
$16.50
3/15/17
Brandon
$17.50
5/1/17
James
$16.50
6/10/17
</tbody>
I've built the table above to record pay rates and effective dates for a pool of...