Hi List, I use paste function to concatenate 3 character columns together. when I run table to see that, I found 3 categories. How can I write script to trim NA in 2nd and 3rd group and set the first one as NA? Thanks, Kai NA NA NA NA NA Adenocarcinoma NA Other NA [[alternative HTML version deleted]]