Spreadsheet: 494184d1482247812-splitting-data-data-sample
Sheet: Desired outcome

Country | Category | ID of person assigned to
China | Blue | 1
China | White | 1
China | White | 1
India | White | 1
India | White | 1
India | White | 1
India | White | 1
UK | Red | 1
UK | Green | 1
UK | Blue | 1
UK | Red | 1
UK | Green | 1
UK | White | 1
UK | Red | 1
UK | Green | 1
UK | White | 1
UK | White | 1
UK | Blue | 1
UK | Red | 1
UK | Green | 1
UK | Red | 1
UK | Green | 1
UK | Red | 1
UK | Green | 1
UK | White | 1
UK | White | 1
UK | Red | 1
UK | Blue | 1
UK | Red | 1
UK | Green | 1
UK | White | 1
UK | Red | 1
UK | Green | 1
UK | White | 1
UK | Green | 1
UK | Blue | 1
UK | Red | 1
UK | Green | 1
UK | White | 1
UK | Red | 1
UK | Green | 1
UK | White | 1
US | Green | 1
US | Red | 1
US | White | 1
US | Red | 1
US | White | 1
China | Blue | 2
China | White | 2
China | White | 2
India | White | 2
India | White | 2
India | White | 2
India | White | 2
UK | Red | 2
UK | Red | 2
UK | Green | 2
UK | White | 2
UK | Red | 2
UK | Green | 2
UK | White | 2
UK | Red | 2
UK | Green | 2
UK | Blue | 2
UK | White | 2
UK | White | 2
UK | White | 2
UK | Red | 2
UK | Green | 2
UK | Green | 2
UK | White | 2
UK | White | 2
UK | Red | 2
UK | Red | 2
UK | Green | 2
UK | Blue | 2
UK | White | 2
UK | Red | 2
UK | Green | 2
UK | White | 2
UK | Red | 2
UK | Green | 2
UK | Green | 2
UK | Blue | 2
UK | White | 2
UK | Red | 2
UK | Green | 2
UK | White | 2
US | Green | 2
US | Red | 2
US | White | 2
US | Red | 2
US | White | 2
China | Blue | 3
China | White | 3
China | Blue | 3
India | White | 3
India | White | 3
India | White | 3
India | White | 3
UK | Red | 3
UK | Green | 3
UK | Blue | 3
UK | Blue | 3
UK | White | 3
UK | Red | 3
UK | Green | 3
UK | Red | 3
UK | Green | 3
UK | Blue | 3
UK | Red | 3
UK | Green | 3
UK | White | 3
UK | Blue | 3
UK | Blue | 3
UK | Red | 3
UK | Green | 3
UK | White | 3
UK | Green | 3
UK | Red | 3
UK | Green | 3
UK | White | 3
UK | Blue | 3
UK | Red | 3
UK | White | 3
UK | Red | 3
UK | Green | 3
UK | White | 3
UK | Red | 3
UK | Green | 3
UK | Blue | 3
UK | White | 3
UK | Green | 3
UK | Red | 3
UK | Green | 3
UK | White | 3
US | Green | 3
US | Red | 3
US | White | 3
China | Blue | 4
China | White | 4
China | Blue | 4
India | White | 4
India | White | 4
India | White | 4
India | White | 4
UK | Red | 4
UK | Green | 4
UK | White | 4
UK | White | 4
UK | Blue | 4
UK | Red | 4
UK | Red | 4
UK | Green | 4
UK | Green | 4
UK | White | 4
UK | Red | 4
UK | Green | 4
UK | White | 4
UK | Red | 4
UK | Red | 4
UK | Green | 4
UK | Blue | 4
UK | Red | 4
UK | Green | 4
UK | Green | 4
UK | White | 4
UK | Blue | 4
UK | Red | 4
UK | Red | 4
UK | Green | 4
UK | White | 4
UK | White | 4
UK | Red | 4
UK | Green | 4
UK | White | 4
UK | Blue | 4
UK | Red | 4
UK | Green | 4
UK | Green | 4
UK | White | 4
US | Green | 4
US | Red | 4
US | White | 4
China | Blue | 5
China | White | 5
India | White | 5
India | White | 5
India | White | 5
India | White | 5
UK | Red | 5
UK | Green | 5
UK | White | 5
UK | Red | 5
UK | Green | 5
UK | Blue | 5
UK | White | 5
UK | White | 5
UK | Red | 5
UK | Green | 5
UK | Red | 5
UK | Green | 5
UK | White | 5
UK | Red | 5
UK | Green | 5
UK | White | 5
UK | Red | 5
UK | Green | 5
UK | White | 5
UK | Green | 5
UK | Red | 5
UK | Green | 5
UK | Blue | 5
UK | White | 5
UK | Red | 5
UK | Red | 5
UK | Green | 5
UK | White | 5
UK | White | 5
UK | Red | 5
UK | Red | 5
UK | Green | 5
UK | Blue | 5
UK | White | 5
US | Green | 5
US | Red | 5
US | White | 5
US | Green | 5
China | Blue | 6
China | White | 6
India | White | 6
India | White | 6
India | White | 6
India | White | 6
UK | Red | 6
UK | Green | 6
UK | Green | 6
UK | White | 6
UK | Red | 6
UK | Green | 6
UK | White | 6
UK | Red | 6
UK | Red | 6
UK | Green | 6
UK | Green | 6
UK | White | 6
UK | Red | 6
UK | Green | 6
UK | Blue | 6
UK | White | 6
UK | Red | 6
UK | Green | 6
UK | White | 6
UK | Red | 6
UK | Green | 6
UK | Green | 6
UK | White | 6
UK | Blue | 6
UK | Red | 6
UK | Red | 6
UK | Green | 6
UK | White | 6
UK | Red | 6
UK | Red | 6
UK | Green | 6
UK | White | 6
UK | Blue | 6
US | Green | 6
US | Red | 6
US | White | 6
US | Green | 6
UK | White | 6