Split data into fairly equal chunks

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!

Preparation

Accepted answers

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

All comments

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

Thanks a lot @OllieClarke!

This is a great solution, thank you!

Quick Links

Tags

This months top contributors

atcodedog05 19598

Qiu 15867

MarqueeCrew 13708

apathetichell 13703