Good day,
I have a table with multiple columns that looks like
A= Num Num_2 ------------------- 2 a 3 a 1 a 2 b 6 a 1 c 7 c
I am trying to add a new column that shows the number of duplication of the values in column Num_2 just like this
ans= Num Num_2 Column_3 --------------------------------- 2 a 1 3 a 2 1 a 3 2 b 1 6 a 4 1 c 1 7 c 2
Best Answer