Check duplicates and type in next column

Help Studio
,
1

Hi All, i am checking duplicates in column and want to type in next column only once. If duplicate values in multiple times.

image

2

Can you share the expected output? @arsalanrasheed143

3

Hello @arsalanrasheed143

  1. Read the range of Column 1 and store value as DT
  2. Use Remove Duplicate Rows, pass the DT as input and output
  3. Use write range and can write from Column2
    image