Delete Duplicate values in a column and keep the rest of the column as is

[saritha]

Hi, 

I am working on a data set where there are duplicate values in multiple columns, the duplicates should be removed and the cells should be left blank. Unique values should be retained for a particular record ID. how can this be achieved, please let me know. 

Current data 

ID	Col1	Col 2	Col 3	Col 4
1	Content	Text 1	Option1	56
1	Content	Text 2	Option1	56
1	Content	Text 3	Option1
1	Content	Text 4	Option1
1	Content	Text 5
2	Text	abd	Option 2	45
2	Text	def	Option 1

Future State

ID	Col1	Col 2	Col 3	Col 4
1	Content	Text 1	Option1	56
1		Text 2
1		Text 3
1		Text 4
1		Text 5
2	Text	abd	Option 2	45
2		def	Option 1

[Qiu · Accepted solution]

@saritha 
Somehing like this?

[saritha]

Yes, this helps, thank you 🙂

[Qiu · Accepted solution]

@saritha 
Appreciate you would mark my answer as accept if you find it helpful.😁