ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   Excel merge columns (https://www.excelbanter.com/new-users-excel/118741-excel-merge-columns.html)

Myrto

Excel merge columns
 
Hallo,

I have two different lists. List A with three columns: name, first name,
email address and list B with 7 columns: name, first name, Street, City, Post
Code, Counrty.
The list B containes the names of list A. How do I merge these two different
lists, so that the e-mail address appears as separate column of List B?


Myrto

Carole O

Excel merge columns
 
Myrto -

If the rows are identical, you could insert a column in list B titled
E-mail, then go to List A, Copy to e-mail column, and paste it in list B.
Just be sure that you are pasting it in the right row.

Carole O

"Myrto" wrote:

Hallo,

I have two different lists. List A with three columns: name, first name,
email address and list B with 7 columns: name, first name, Street, City, Post
Code, Counrty.
The list B containes the names of list A. How do I merge these two different
lists, so that the e-mail address appears as separate column of List B?


Myrto



All times are GMT +1. The time now is 01:21 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com