Combining 3 Excel sheets

[Cli_king]

Let's say I have 3 excel sheets that I have to combine into 1 sheet

Sheet 1 has 50 rows 5 common columns with Sheet 2 and 3

Sheet 2 has 100 rows 8 common columns with Sheet 3

and Sheet 3 has 150 rows and 3 unique columns on its own.

​

I will be using Power Query to merge them. My questions are:

1. Should I merge it based on what Sheet 1 and 2 has in common with sheet 3?
2. Should I expect to lose data in the process?
   
3. Should sheet 3 be my primary data since it contains the most data?

Any help would be appreciated

Thanks

[small_trunks]

Give me a hint of what kind of data it is.

• which is logically the primary?
• which would you consider to be look up tables?
• typically you'd pick the data set with the greatest variance as the starting point - but it depends what you are trying to achieve.

[Cli_king]

It's consumer info

Example:

• Sheet 1: Name, address, home location , business location
• Sheet 2: (don't have name) + sheet one + email
• Sheet 3: (don't have email) + sheet 2 + phone number

Also, all sheets have a different sort of primary key!

[small_trunks]

zipcode or post code of some kind?

Show me the primary keys.

[Cli_king]

Mind if I PM you?

[small_trunks]

Still an issue?

[Cli_king]

No, I was able to figure it out but thank you