Combine multiple sheets to one by "overlaying them"

[Svexcel]

Hi!

I need to combine multiple sheets to one "master sheet".

The problem is that there is no unique id. But it can be created by combining the two columns (In this example Number & Name). But then the sheets have different amounts of rows also.

How can I "overlay" so that I get all the information into one sheet?

Grateful for any help!

 

[alansidman]

Using Power Query. See link

Combine Data From Multiple Worksheets into a Single Worksheet in Excel

In this tutorial, you'll learn how to quickly combine data from multiple sheets into one single worksheet (using Power Query).

trumpexcel.com

 

[Svexcel]

Unfortunately this is not a solution. As I wrote I do not have a unique id. and this solution just stacks everything and gives a lot of duplicates.