How to remove duplicate cells, keeping rest of the columns value same

Help Activities
, ,
1

Book1.xlsx (9.9 KB)
how to remove duplicate cells, keeping rest of the columns value same.
In attached file 1st sheet, 1st col has duplicate i want to remove Duplicate values, keeping rest of the data as it is.

Any linq for the same as data is huge.

2

@8b6861dc5e0c9f7008548ca66

can you try this by using invoke code activity

Dim previousvalue As String
For Each row As DataRow In dt.AsEnumerable
If row(0).ToString=previousvalue Then
	row(0)=""
	Else
		row(0)=row(0).ToString
		previousvalue=row(0).ToString
	End If
	Next

image
image1029×711 34.4 KB

1 Like