Pivot Data Strings Per ID

[Rogers2212]

Hi, I have been stuck on this query for a while looking to see if anyone has any ideas on how to do this?

I have a long data set that looks similar to this 

interation_ID	Name	leg_ID
1000001	John	1
1000001	Jack	2
1000001	Jeff	3
1000001	July	4
1000002	Jack	1
1000002	Alex	2
1000003	Rachel	3
1000003	Chris	4
1000003	Simon	5
1000003	Toby	6
1000003	Joy	7
1000003	Ryan	8
1000003	James	9

As i now need to build a sankey chart i am trying to get the dataset to be wide as opposed to long. IE 

1000001	John	Jack	Jeff	July
1000002	Jack	Alex
1000003	Rachel	Chris	Simon	Toby	Joy	Ryan	James

[Or]

Have a look at solutions using Generic Load and then table concatenation:

https://qlikviewcookbook.com/2010/05/use-cases-for-generic-load/

Or loop-based solutions that don't use Generic Load:

https://community.qlik.com/t5/New-to-Qlik-Sense/how-to-combine-after-generic-load/td-p/1380839