Join two columns on multiple values and combine them in one cell in excel

[SouravKayal]

HI Team,

I have a data set that i need to merge.

Data set 1

ID

1

2

3

4

Data Set 2

ID	Names
1	Alpha
1	Beta
2	Gamma
3	Test
3	Alpha
4	Test1
4	Beta
4	Gamma
4	Alpha

Desired Output:

ID	Names
1	Alpha Beta
2	Gamma
3	Test Alpha
4	Test1 Beta Gamma Alpha

Appreciate if someone can help me in the right direction.

[Jay-RDC]

Hi, Join Tool should work and just join them by ID.

[SouravKayal]

Join tool will get them in different rows i want to show them under 1 row if multiple values seprated by bullets or a delimiter

[cjaneczko]

You can use a Summary Tool and group by ID and Concatenate by Name. You only need Dataset 2 in this instance. I dont think you can use a bullet, but you can use any other delimiter you can think of.

[SouravKayal]

can you help with a test workflow ?

[MilindG]

@SouravKayal 

[cjaneczko]

Add a sort tool after it if you want the ID's in order. 

[Raj]

@SouravKayalare you looking for output in PDF output or Xlsx format.
have you explored reporting tools?

[cjaneczko]

If its in excel you can also use \n in stead of the comma as the separator and it will put a Carriage return inside the cell and present it just like you have it, less the bullet. 

[Jay-RDC]

@cjaneczko Solution should work for you. If you need the bullet point format you would need to add a condition for that to separate 1 entry vs multiple. An output tool might not work for the bullet point format so better use table tool (add the condition/logic here for the bullet point) then render tool for your output.