Hello,
I have been requested to reorganize a production schedule report for my company until our new MRP system is implemented. I have exhausted my knowledge of functions such as XLOOKUP, FILTER, INDEX / MATCH, and others without being able to find a solution for making this report update. Any help is greatly appreciated.
In the screenshot below I've created a similar production report using arbitrary vehicle information. As you can see the Model is on the X-axis with dates and production volume on the Y-axis. The goal for my output is to essentially transpose the production dates and quantities into columns with their respective models. E.g. a batch of Silverados were produced between two separate states the weeks of 1/2/23, 1/9/23, 1/16/23, 2/6/23, and 2/20/23 so the new report would list those five weeks along with the quantities produced those weeks, ignoring weeks of non-production.
