I want solution of my issue

Hi @Shubham_Bidwai ,

Check with the below Steps :

  1. Read the Excel Sheet as a Datatable using Read Range Activity. Get the Datatable, say DT.

  2. Next, Create another Datatable to create the Output data, say OutputDT. Assign the clone of the Input datatable to this Output Datatable like below using an Assign Activity.

OutputDT  = DT.Clone
  1. Next, we’ll use the below Linq in an Assign Activity to Group By and Concatenate the values based on the Column Name :
OutputDT = (From d In DT.AsEnumerable
Group d By k=d("Name").toString.Trim Into grp=Group 
Let cn = String.Join(Environment.NewLine, grp.Select(Function (r) r("Task").toString).toArray)
Let ra = New Object(){k, cn}
Select OutputDT.Rows.Add(ra)).CopyToDataTable

Visuals :

Let us know if you are able to understand the above approach.

Also take a look at the Grouping options and documentation :

1 Like