I've searched for "round robin", and unfortunately, I couldn't find what I think I stumbed on a few months ago...eeee.

I'd like to create a spreadsheet that will combine the column vs. the row for a round robin...and the list will be a straight column.

There could be an uneven # of either column or row...

The numbers would be generated by formula too, hopefully....
hd1 hd2 hd3 hd4
hl1 1 5 9 13
hl2 14 2 6 10
hl3 11 15 3 7
hl4 8 12 16 4

1 b2 a2
2 c3 a3
3 d4 a4
4 e5 a5
5 c2 a2
6 d3 a3
7 e4 a4
8 b5 a5
and so on

any idears?