Redundant tables in model

Hi Enigma 

Now you can save couple steps and work on 1 table from the beginning

1- if you connect power bi to your workbook you will have to check all sheets and import them, this will display 10 tables, what I suggest you to do is to import only one sheet 🤔, Yes only 1 sheet.

You will get then the below preview

2- in the steps tab select the 1st step and you will able to expand data from all sheets without loading all sheets or append them

3- in this table you will need to add couple transformations to clean rows and keep the needed columns 

Does it work ? Mark it as a solution 

A kudos would be appreciated