To get the desired outcome, create a calculated field similar to the following:
if total(count(Column2))>1 then 1 else 0 end
Then, place this on the view. Right click on it and select Edit Table Calculation... Choose the Advanced function and select Advanced... Place Column2 and then Column1 in the compute using box. Choose Column1 for At the level and restarting every Column2.
Hope this helps!
Great ! This is exactly what I wanted !
Thank you Tracy !