July 23, 2023
I am writing because I am looking for a way to create a table with information from different Excel sheets using Power Query. These Excel sheets correspond to a production plan. The problem is that in the same column, I have the SKU and the batch number, and in different columns, there are dates with the planned quantities for each date, as well as the actual quantities achieved for each date.
Attached, you will find an example. The first sheet is named "MPS," and that's where I want to extract the information. The second sheet is named "Expected result," and I have provided an example of how I would like the data to be displayed.
Thank you in advance, and please let me know if you need more information.
Xtreme Pivot Tables
Excel for Decision Making
Excel for Finance
Excel Analysis Toolpak
Excel Customer Service
November 8, 2013
See attached example.
Most common problem is when you want to store data into a structure designed for visual purposes.
"Eye friendly" structures should just be the output from data properly stored in tabular format. Tabular structure is not visually friendly but in the same time structures that are designed to be clear and intuitive are very difficult to manipulate and they should not be used as data entry forms and visuals in the same time.