How to add group number to equally divide number of rows

Hi folks

I'm running Office 2013 and I have a table with 10 columns and 5000 rows, all rows are orders that we, 6 of us, need to work on.

Instead of copying/pasting data around, I'd like to add a column named "Group" at the beginning of the table and add a function which assigns group 1, 2, 3, 4, 5, 6 with equally number of items.
Then, we can divide the work by filtering the table based on the assigned group number.

Is this possible?

Thanks for reading.

...Alex

Please post a file showing the calculation(s) you require.

John,

See attached.

report.xlsx

Thanks,
...Alex