Hello! I have a table… [image] And I want to group by Col2 and Col9 And the output should be [image] (From d In dt.AsEnumerable Group d By k1=d("Col1").toString.Trim, k2=d("Col2").toString.Trim Into grp=Group Let ra = New Object(){k1,k2, ? ? ? ? ? } Select test.Rows.Add(ra)).CopyToDataTable …

LINQ group by 3 columns but display all of them

ppr (Peter Preuss) January 13, 2022, 7:09pm 2

its depending on how you have decide from which group member to take the value
in case of taking it from first group member we would use for ?
grp.First()(YourColNameOrIndex)

Topic		Replies	Views
Excel linq group rows based on two rows in a datable and also if second column is distinct Activities excel , activities , question	2	1151	November 24, 2021
Linq group by and concatenate Studio	3	1691	August 26, 2022
Group by Studio	3	633	November 19, 2022
Using Group by for more than two columns using Linq Activities datatable , uiautomation , activities , question	5	6705	November 9, 2021
Grouping and eliminating excel columns Studio datatable , excel , studio , question , activities_panel	8	2161	July 1, 2021

LINQ group by 3 columns but display all of them

Related topics