Split data into fairly equal chunks

[Mert]

Hi. I have a piece of data (email addresses). Let's say they are 7 in total and I want to split them to 3 smaller chunks.

ID

A

B

C

D

E

F

G

Desired Outcome is

A

B

C
D

E

F

G

In another scenario if they are 6 in total and I want to split them into two chunks, then

A

B

C

D

E
F

I could neither think of a solution myself nor managed to find a topic discussion in Community. Is this possible with Designer? TIA!

[OllieClarke · Accepted solution]

Hi @Mert you can use the tile tool to do this. 

Choose 'Equal Records' and the number of groups you want:

3 groups2 groups

The Tile_Num will be the grouping field.

Hope that helps,

Ollie

[Mert]

Thanks a lot @OllieClarke!

[YcMing]

This is a great solution, thank you!