Group multiple rows into single row using linq

[mentavenkatesh (Venkatesh Menta)]

Hi Team,

How to group the multiple rows into single row using Linq.

Input:
User Hobby

Bob Football
Bob Golf
Bob Tennis
Sue Sleeping
Sue Drinking

Output:
User Hobby

Bob Football, Golf, Tennis
Sue Sleeping, Drinking

[Srini84 (Srinivas Kadamati)]

@mentavenkatesh

Welcome to community

You can refer below post

Group data table by value and join results in caret list

I have a data table with 2 columns I want to group the data by column 1 and join the data in column 2 with ^ separating each value. I have a simple example below of data and then what I want the output to be, but I’m struggling with how to write something to accomplish this. [image]

Mark as solution if this helps

Thanks

[mentavenkatesh (Venkatesh Menta)]

Hi,

Thanks for your response. Actually i have 20 columns in the data table. please suggest me how to do.

[supermanPunch (Arpan)]

@mentavenkatesh Can you provide us a Sample data of the Excel having 20 Columns, also appreciated if you could show us the Expected Output based on the Input File.