Replace one row name(thaar) with row name(Audi) in excel in uipath

[ashokkarale]

@Shravan_Pintu,

Use this logic.

LINQ to print the counts

String.Join(", ", (From row In dtInput.AsEnumerable
                   From col In dtInput.Columns.Cast(Of DataColumn)
                   Group row(col.ColumnName).ToString.Trim.ToLower By fruit = row(col.ColumnName).ToString.Trim.ToLower Into Group
                   Select $"{fruit} {Group.Count}").ToArray)

Code:
TestProject (2).zip (60.0 KB)

Output: