I've been looking around, but without knowing the technical term for what I'm attempting I've struggled to find a solution.
here's an example.
Sheet 1
<tbody>
column a
column b
column c
column d
column e
00emp
12345
29012019
A12345
00emp
12346
29012019
A12346
</tbody>
Sheet 2...