Create Columns based on variable

Pokayoke

Hi there--Alteryx Beginner here with a process improvement question.

Here's my scenario--I've got group numbers and personnel assigned to each group.  If there is more than 1 person per group, I want to output them in additional columns.  For example:

Input:

1	Bob
2	Alice
3	Susan
4	Bob
5	Bob
6	Alice
7	Susan
8	Susan
1	Alice
1	Susan
8	Alice

Output:

Group	Person 1	Person 2	Person 3
1	Bob	Alice	Susan
2	Alice
3	Susan
4	Bob
5	Bob
6	Alice
7	Susan
8	Susan	Alice

I am currently trying to do this with the Tile tool, but it's not very refined.  I get unique tiles, filter on tile sequence and join to add the columns. 

But it's sloppy because if there are more than 2 names, I have to do multiple joins.  I am wondering if there is a way to make the flow iterate through the potentially changing number of name each week by reading the tile sequence number as a variable to create how ever many columns I need. I feel like there's probably a way to do this with the Formula tool, but I'm not experienced enough with Alteryx to figure it out yet.  (i.e.  If TileSequence = 4, create and populate 4 columns) Any ideas?

Thanks!

jamielaird

Hi @Pokayoke 

Here's a nice simple solution that achieves what you are looking for. Let me know if you have any questions.

Cross Tab Groups.yxmd