let me get this.

for example, there are three rows for 'ram living in NY, NY'.

so, u want all three rows still intact, and have all the distinct information from extra1, extra2 and extra3 received from all three rows be concatenated but separated by comma, and then store that value in concatenate col in all the three rows?

what programming language u are trying to use, or u wanted to just use sql?