Generate shuffled list

[chris4987]

Hi, I have a list of managers and analysts that need to be shuffled each quarter. there is 1 manager for each team and each quarter the analysts get shuffled around. I need some assistance on how to create this workflow. Thanks in advance

Input

Manager	Andrew
Manager	Elijah
Manager	Isaac
Analyst	Brianna
Analyst	Chris
Analyst	Derek
Analyst	Farah
Analyst	Garrett
Analyst	Harrison
Analyst	Jarred
Analyst	Karen

Output

Q1			Q2			Q3
Manager	Andrew		Manager	Andrew		Manager	Andrew
Analyst	Brianna		Analyst	Farah		Analyst	Harrison
Analyst	Chris		Analyst	Jarred		Analyst	Garrett
Analyst	Derek					Analyst	Karen
Manager	Elijah		Manager	Elijah		Manager	Elijah
Analyst	Farah		Analyst	Brianna		Analyst	Chris
Analyst	Garrett		Analyst	Derek		Analyst	Jarred
Analyst	Harrison		Analyst	Karen
Manager	Isaac		Manager	Isaac		Manager	Isaac
Analyst	Jarred		Analyst	Chris		Analyst	Brianna
Analyst	Karen		Analyst	Harrison		Analyst	Derek
			Analyst	Garrett		Analyst	Farah

[mceleavey]

Hi @chris4987 ,

I've achieved this by using random number generation and sorting by this, then using the tile tools to assign managers and analysts to equal sum tiles. I then joined the analysts to managers using the assigned tile number. You can then copy this out for as many Quarters as you wish to assign in the future.

The number of tiles corresponds to the number of managers.

Workflow attached.

I hope this helps.

M