Dear All,

I have some huge data table (sample attached)
the data is coming from past and the format was developed earlier by someone.

The data in the "DATA" sheet is already in pivot shape and its too hard to enter daily data in the format for hundreds of locations.
I want to unpivot old data in table shape "as in NEEDED FORMAT" and then will make Pivot Table for auto generation.

Can you please Help.
Pivot.xlsx

I know some data conversion can be done via Powerquery but here there are more than 4 headers.