Hi! I have 2 files
First file is with data which is paired in "Data groups" as shown in table below.
Second file has list of resources who need to allocated to these data records but we need to ensure that every "Data Pair ID" has 1 resource name allocated and the total number of records should be allocated equally across the employees.
Also the number of employees can be dynamic, for example in this list there are 5 employees, sometimes it can be 4 or 3 as well.
Will most definitely appreciate any suggestions.
| Data Pair ID |
| 471782 |
| 471782 |
| 471724 |
471724 |
| 471668 |
| 471668 |
| 471596 |
| 471596 |
| 471551 |
| 471551 |
| 471788 |
| 471788 |
| 471571 |
| 471571 |
| 471563 |
| 471563 |
| 471554 |
| 471554 |
| 471649 |
| 471649 |
| 471569 |
| 471569 |
| 471580 |
| 471580 |
| 471568 |
| 471568 |
| 471573 |
| 471573 |
| 471566 |
| 471566 |
| 471567 |
| 471567 |
| 471575 |
| 471575 |
| 471576 |
| 471576 |
| 471595 |
| 471595 |
| 471799 |
| 471799 |
| 471581 |
| 471581 |
| 471525 |
| 471525 |
| 471536 |
| 471536 |
| 471531 |
| 471531 |
| 471532 |
| 471532 |
| 471537 |
| 471537 |
| 471543 |
| 471543 |
| 471542 |
| 471542 |
| 471544 |
| 471544 |
| 471796 |
| 471796 |
| 471661 |
| 471661 |
| 471620 |
| 471620 |
| 471538 |
| 471538 |
| 471553 |
| 471553 |
| 471602 |
| 471602 |
| 471604 |
| 471604 |
| 471601 |
| 471601 |
| 471600 |
| 471600 |
| 471603 |
| 471603 |
Here is the resource list
| Primary Resource |
| Sam |
| Sandi |
| Zeesh |
| Sud |
| Baba |
