Assigning names to records

Question

Hello,

Please see attached input and desired output tabs.

There are three types of actions in "Action to take" column. "Do this 1" is associated to names A,B,C, "Do this 2" is associated to names D,E,F, "Do this 3" is associated to names G,H,I,J. Assign name (A,B,C,D,E,F,G,H,I) for each group for each action equally or close to equally such that each name is assigned an equal number of records in their group.

Thank you!

+Master.xlsx

Qiu · Answer

@htalteryx 
We can do it by a batch macro so it is also dynamic.

0826-hdtruong.yxzp

DataNath · Answer

Hey @htalteryx, how does something like this look? I've made use of the Tile tool to split the records into even groups, before giving them their relevant letter:

I've used the 3 Summarize tool as a form of validation, just to group these records and show how they're evenly split:

Assign equal names to records.yxzp