Nullifying Repeated Numbers in a Column

[CVKing]

I have one column that has the same value repeated thousands of times, and the data samples can be hundreds of thousands of rows. I am trying to make all of the repeated values in one column null, while keeping the rest of the row. I have tried using multi row with the following formulas without success, as they only nullify every other row. 

'If ([Row-1:Column Name] = [2Column Name]) then Null() Else [Column Name] endif'

and

'If ([Row-1:Column Name] != [Column Name]) then [Column Name] Else Null() endif'

How can I nullify thousands of repeated values in a column?

[Mathias_Nielsen]

Hi @CVKing,

Have you tried the "Only unique" Crew macro? I think this could solve your issue. Even using the "Unique" tool you could make a solution to solve your problem by joining the Unique and Duplicate output. Everything in the left (unique) output should be truly unique :)

Hope this helped you :)

[nickmartella · Accepted solution]

I think you would need to add a sort tool before the multi row formula - sort by the column you want to nullify repeated values, then add the multirow formula like this:

If [Row-1:ColumnName] = [ColumnName] Then Null() Else [ColumnName] Endif

[Raj]

@CVKing 
add some sample input and expected output in excel format

[nagakavyasri]

@CVKing Add a new column in multi row formula