Restructuring and Condensing Data Set

shelbybradley

Hello, 

I am having trouble restructuring my data set to only include the critical columns I need. The data currently looks like this, with the critical info underneath a bunch of extra data. 

Output:

I would like the data to have the column structure be condensed to:

- Product

- Week (with all the dates in one column)

- Demand

- Stock

- Supply

- GAP

Any help is much appreciated. 

Thanks

Illustrative data 2.xlsx

Blake

Is this what you're looking for? I left 'Inputs' as a key field but that can easily be removed. See attached for the .yxzp

SB.yxzp