Hi, I have three columns based on column A i need to join the remaining two columns as shown below. Column A startpage Endpage Item 1 1 1 Item 2 3 3 Item 1 4 4 Actual o…

Hi @Navya_Nadakuduti How about this expression (From d In DtBuild.AsEnumerable Group d By k=d("Column A").toString.Trim Into grp=Group Let B =String.Join(",",grp.Select(Function (x) x("Start Page").toString.Trim+"-"+x("End Page").toString.Trim)) Let ra = New Object(){k, B} Select DtClone.Rows.Add(…

Group two column values with unique column

Help Studio

Gokul001 (Gokul Balaji) November 19, 2022, 7:18am 6

Great @Navya_Nadakuduti

Kindly close this topic by mark as solved. It will help for other too.

Regards
Gokul

Topic		Replies	Views
Group data table by value and join results in caret list Help question	6	2726	June 11, 2020
Group two columns Help orchestrator , activities , studio	11	1454	August 3, 2019
Linq group by and concatenate Studio	3	1628	August 26, 2022
Combining Datarows based on Unique Columns Activities datatable , excel , activities , studio , question	9	1022	July 31, 2021
How to group by multiple columns from a datatable Activities datatable , excel , activities , question	5	7275	December 23, 2020

Most Active Users - Yesterday
sharazkm32
singh_sumit
ashokkarale
lrtetala
prashant1603765
sonaliaggarwal47
Justin_Tan_Jun_Song_EE
Anil_G
mively
shrikrushna.bhoi
More details...

Group two column values with unique column

Related topics