append two columns from the same table

[rollingzep]

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 the append?

TIA

[serpiva64]

Hi,

can you post some sample data?

[Syk]

Select the 2 columns you'd like to combine > right click one of them > Merge columns

[Syk]

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

[rollingzep]

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.

[serpiva64]

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!