Merge multiple rows of the same ID in one column

[vkal12]

Hello everyone,

I know that this question has been asked many times before but I cannot find the right way to achieve the goal in my Qlik Sense app.

This is how my table looks at the beginning: 

ID	Type	Name
10001	A	Mike
10001	B	Lucy
10001	C	Sina
20001	A	Meredith
20001	B	Anna
30001	C	Lisa
40001	A	Michael
40001	A	Jordan
40001	A	Max
40001	C	Sabrina

Out of this table I want to create new colums for each Type where I concatenate the Names for this Type. So the result should look like this: 

ID	A	B	C
10001	Mike	Lucy	Sina
20001	Meredith	Anna	-
30001	-	-	Lisa
40001	Michael, Jordan, Max	-	Sabrina

I do not want to change something within the load script but within the chart / table itself. 

I hope someone has an idea for me and can help me with my problem. 

Thank you very much in advance!

[Or]

Looks like a standard pivot table with the dimensions being ID, Type (pivoted), and Concat(Name, ',') as the measure, if I understand it correctly?