Transfer table to unique row dataset

Hi everyone,

ive encountered an issue where I need to organize the data differently for ease of analysis and data visualization.

Currently a group of people is maintaining an overview showing orders (forecasted, and firm orders). They are shown per calender week in a row.

Ideally I would like to have a new overview where all information is placed in rows. Each row should be a unique combination of Customer name-Weeknumber-Order type-Quantity.
Unfortunately it is not possible to adjust the source overview as it is being used in many running processes.

Is there any way to easily create a new overview as described in the attachment.
Ideally i would like to link these 2 overviews so that it is maintened when in the original overview information is adjusted/added.

I hope someone has a clever idea on how to go about this !

thx