I'm working with a long list which is a bunch of names in one column - they are in teams of a maximum of 5, but usually less so I need to create blanks rows to keep things in order:
Column A/B is what I need to achieve - from the basic list I get in column E...
<tbody>
</tbody>
Is there any way to Insert (Blank) Rows automatically to the list I get in column E ?
Column A/B is what I need to achieve - from the basic list I get in column E...
A | B | C | D | E |
TeamA | 1 | Jack | Jack | |
2 | Jill | Jill | ||
3 | John | John | ||
4 | Jane | Jane | ||
5 | ||||
Tom | ||||
TeamB | 1 | Tom | Harry | |
2 | Harry | |||
3 | Bill | |||
4 | Phil | |||
5 | Bob | |||
Rob | ||||
TeamC | 1 | Bill | ||
2 | Phil | |||
3 | Bob | |||
4 | Rob | |||
5 | ||||
<tbody>
</tbody>
Is there any way to Insert (Blank) Rows automatically to the list I get in column E ?