Thanks JG. It worked using Aggr ( I had to uncheck the "Include null values" option for this column.) and also the solution you gave. I am using the solution you provided since Aggr would use large resources.
Thanks for the help on this. I appreciate you putting your time to solve my challenge.