Guys, is there a way to via vba move all of the names so there are no gaps so example 1 looks like example 2. The data is currerntly in range c22 to E40 in sheet called 'Allocate'
EXAMPLE 1
<colgroup><col span="2"><col></colgroup><tbody>
Name1
Name2
Name3
Angela Rose
Bethan Mason...