Forum Discussion
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...
Select the 2 columns you'd like to combine > right click one of them > Merge columns
A quick note.. If you want to keep your original 2 columns, navigate to the Add Column tab > Select columns > Merge Columns in the ribbon
I don't want to merge, I need to append. I do not need something like lastname, firstname. I need it as one below the other. I need col B values below col A.
Hi,
I tried to do this way and it functions (in my case)
- Duplicate your table
- in the duplicated table rename ISIP_ID as ISIN_ID and viceversa
- then append as a new query
- remove duplicates
If this post is useful to help you to solve your issue, consider giving the post a thumbs up and accepting it as a solution!
