Join data

[stormania]

Dear Excel Master

Kindly help
How to make a recap report (in report sheet - blue color) from several existing sheets so that it becomes one data in report format.
Is it possible if use Query Excel ?

Thank you

 

[Peter Bartholomew]

I am far from being a Power Query specialist but this seems to be working. The first problem is that the purchase order table and planning table seem to be an extension of one another but neither has a primary key. I have inserted a key to make the join simpler though it probably isn't necessary. There was also redundant data which I removed before looking up values from the dimension tables.

 

[vletm]

stormania​

You opened this thread to Ask an Excel Question ...
Your last words are something about Query Excel ...
I tested this 'my way' using Your given sample data.
... click [ Do It ]-button to get ... something with visual (which can hide too).
Is it something that You expected?

 

[stormania]

I am far from being a Power Query specialist but this seems to be working. The first problem is that the purchase order table and planning table seem to be an extension of one another but neither has a primary key. I have inserted a key to make the join simpler though it probably isn't necessary. There was also redundant data which I removed before looking up values from the dimension tables.

Dear Peter

Thank you for explain the answer

 

[stormania]

stormania​

You opened this thread to Ask an Excel Question ...
Your last words are something about Query Excel ...
I tested this 'my way' using Your given sample data.
... click [ Do It ]-button to get ... something with visual (which can hide too).
Is it something that You expected?

Dear vletm

Your answer verryy amazing that make me surprise how to make that or any link to learn something like that? thank a lot