Forum Discussion
Merge two columns into one, but with unique values
Anonymous ,
I would approach it this way:
1) Copy your first query to create a second one.
2) In the first query, delete column 2. Rename Column 1 to New Column
3) In your second query delete Column 1. Rename column 2 to New Column
4) Use the Append Queries function to append these columns together. I would choose "Append Queries as New"
5) Then you can delete the first two queries.
Hope this or some alternative to this will help you get on your way. There may be a cleaner solution, but I thought that I'd at least throw this idea ou to you.
Regards,
Community ChampionAnonymous ,
I would approach it this way:
1) Copy your first query to create a second one.
2) In the first query, delete column 2. Rename Column 1 to New Column
3) In your second query delete Column 1. Rename column 2 to New Column
4) Use the Append Queries function to append these columns together. I would choose "Append Queries as New"
5) Then you can delete the first two queries.
Hope this or some alternative to this will help you get on your way. There may be a cleaner solution, but I thought that I'd at least throw this idea ou to you.
Regards,
Thank you! such a simple way to do it, so smart!!
- rsbin
Anonymous ,
Glad that it worked out for you and happy to help.