append two columns from the same table

Hi,   On my table, TBL1, I have two fields, ISIP_ID and ISIN_ID. I need to combine them into a single column CUSIP_ID while eliminating the duplicates and blanks. If I add a new column, how do I do...