I import team performance data. The teams may have 12 players but jersey
numbers may run from 1 to 20. The numbers are not sorted..

In a simplified way I receive data as under B and would like to have them
parsed as under C There will be at least 6 matches and four teams at
different sheets.Could this be done with a scrpt.

A B C

1 1 1

2 4 -

3 3 3

4 4

etc

20

1 1 1