Round Robin Assignment using Power Query | Rotating List

In case you need a Round Robin Assignment in Power Query. You can use the combinations of Add Index Column, Add Modulo Column, and then Merge.

[excelnewb]

Alternatively, you can use Index From 0, and no need to add +1 on the M code

[jweg]

Hi, your video was extremely helpful! I am trying to learn how to assign based on a certain task type and also how to load in new tasks to be assigned from a folder as a drop off point.

[chillentimes]

dude... good info.. .but you need to speak louder.... I had to turn up all my volume.

[Joe-qxki]

How about when you have batches of tickets distibution at the same day? You need to start allocating the 2nd batch of tickets to the employee after the last employee assigned from the fist batch. How to do that?

[BronzeVBaker]

what if there are part-time employees and they get a different weight?