How to merge columns?

[Guest]

I want to merge 2 columns of email addresses (some are dupes).

 

[Steve Schapel]

Kelly,

Assuming you are talking about 2 fields in a table in an Access
database, you can make an Append Query, based on the table, to append
the data in the second field back into the first field of the same
table. Then simply delete the second field.
Hint: make sure you have backup of database first!

 

[Guest]

How do I make an Append Query within Excel?

Kelly,

Assuming you are talking about 2 fields in a table in an Access
database, you can make an Append Query, based on the table, to append
the data in the second field back into the first field of the same
table. Then simply delete the second field.
Hint: make sure you have backup of database first!

 

[Steve Schapel]

Kelly,

As far as I know, you can't.

The focus of this newsgroup is Access. Maybe try in an Excel newsgroup.