Combining rows

[sreekanthac]

Hello Community,

I have a situation where I need to combine the records or rows. I am looking for a possible solution. 

My source file is as shown below. I need to generate one row per Singer combining all the songs.

Name	Last Name	Song1	Song2	Song3	Song4	Song5
Micheal	Jackson	xxx		zzz	aaa
Micheal	Jackson		yyy			bbb
Shakira	Ripoll	111		333
Shakira	Ripoll		222			555
Shakira	Ripoll				444

The output should look like below.

Name	Last Name	Song1	Song2	Song3	Song4	Song5
Micheal	Jackson	xxx	yyy	zzz	aaa	bbb
Shakira	Ripoll	111	222	333	444	555

Thanks in advance for your input.

BR

Sreekanth

[sreekanthac]

I found the solution as below.

In case you have any other suggestions, do let me know.

[binuacs]

@sreekanthac 

Spoiler

[sreekanthac]

@binuacs Thanks for the suggestion. I was just wondering with many more fields (say 85 which infact is my actual situation), is using Summarize Tool a good practice?

[binuacs]

@sreekanthac I would suggest you to try both options and see the performance. 

[Qiu]

@sreekanthac 
I would say that the solution provided by @binuacs is more dynamic and can handle any number of columns without changing the flow.

While Summarize tools is more static in the sense of columns.