Hello everyone, Book1.xlsx (9.3 KB) I have attached the input file. I need output in this format. Can anyone help me solve this… [image]

HI, How about the following? [image] dtResult = dt.AsEnumerable.GroupBy(Function(r) r("Employee ID").ToString).Select(Function(g) dtResult.LoadDataRow({g.key}.Concat(arrCol.Select(Function(c) g.Where(Function(r) r("Leave Type").ToString=c).Sum(Function(r) Double.Parse(r("Days/Hours Taken").ToSt…

Need to sum values in the column and separate into multiple columns

Help Something Else

arivu96 (Arivazhagan A) November 25, 2022, 10:25am 2

Hi @poojadass.murugadass ,

Use PIvot table activity or use Macro to create a output like above.

Regards,
Arivu

Topic		Replies	Views
How to sum the column values using LINQ Activities excel , activities , question	6	2632	November 2, 2022
Create table for report (new sheet)? Activities excel , activities , question	15	1173	April 4, 2022
Sum of Multiple rows Activities excel , activities , question	2	1495	January 15, 2022
Sum_Multiple Data_Rows_LINQ Activities excel , activities , question	4	50	August 10, 2024
Sum of rows on multiple columns Studio studio , question , activities_panel	8	53	March 14, 2025

Need to sum values in the column and separate into multiple columns

Related topics