How to combine two Excel spreadsheets into one

[KCav45]

I have two Excel spreadsheets with information about My Contacts that I would like to combine. Each contact is on one line and the columns have information like address, phone number etc. What should I do to combine the two worksheets.

 

[Larry Haydn]

If the columns are the same, you can just copy from sheet A and paste into sheet B.
After that, you may want to sort the result by contact name, to see if there are duplicates.

 

[rjmdc]

you can use append in powerquery