Combining excell files

Copper Contributor

I have three excel files that are membership lists.  First name, last name, etc.  Six columns total in each.

How do I combine them into one list?

Using Office Home and Student 2019.

Thank you.

1 Reply

@edCourtney 

I'd copy/paste the lists into a single sheet, one below the other.

If there are duplicates, you can use Data > Remove Duplicates to delete them.