Spreadsheet: 888626d1739200036-power-query-re-shaping-data-reshape-data-1-
Sheet: Sheet1

Column1 | Column2 | 1/1/2025 | Column3 | Column4 | Column5 | Column6 | 1/2/2025 | Column7 | Column8 | Column9 | Column10 | 1/3/2025 | 1/3/2026 | 1/3/2027 | 1/3/2028 | 1/3/2029 | Column11 | Column12 | Column13 | Column14
CODE | NAME | WEIGHT | GROWTH RATE | CONTRIBUTION | VALUE | PRICE | WEIGHT | GROWTH RATE | CONTRIBUTION | VALUE | PRICE | WEIGHT |  |  |  |  | GROWTH RATE | CONTRIBUTION | VALUE | PRICE
AAA | PRODUCT AAA | 40 | -2.435316834477169 | -0.9741267337908678 | 100 | 1 | 12 | -0.8281271418122262 | -0.09937525701746715 | 80 | 5 | 23 |  |  |  |  | -2.722711364911723 | -0.6262236139296963 | 60 | 9
BBB | PRODUCT BBB | 30 | -4.90380850438732 | -1.471142551316196 | 200 | 2 | 35 | 2.224387826047646 | 0.7785357391166762 | 180 | 6 | 17 |  |  |  |  | 4.402034191476471 | 0.7483458125510001 | 160 | 10
CCC | PRODUCT CCC | 15 | 2.375646414033097 | 0.3563469621049646 | 300 | 3 | 45 | -4.258124387349414 | -1.916155974307236 | 280 | 7 | 48 |  |  |  |  | -1.978702210579 | -0.9497770610779198 | 260 | 11
DDD | PRODUCT DDD | 15 | -1.346001269098974 | -0.2019001903648462 | 400 | 4 | 8 | 2.498535609543886 | 0.1998828487635109 | 380 | 8 | 12 |  |  |  |  | 0.139183936794451 | 0.01670207241533411 | 360 | 12
TOTAL |  | 100 | -2.290822513366946 | -2.290822513366946 | 1000 |  | 100 | -1.037112643444517 | -1.037112643444517 | 920 |  | 100 |  |  |  |  | -0.8109527900412818 | -0.8109527900412818 | 840
 |  | 2025-01-01 00:00:00 | 2025-01-02 00:00:00 | 2025-01-03 00:00:00 | 2025-01-01 00:00:00 | 2025-01-02 00:00:00 | 2025-01-03 00:00:00 | 2025-01-01 00:00:00 | 2025-01-02 00:00:00 | 2025-01-03 00:00:00 | 2025-01-01 00:00:00 | 2025-01-02 00:00:00 |  |  |  |  | 2025-01-03 00:00:00 | 2025-01-01 00:00:00 | 2025-01-02 00:00:00 | 2025-01-03 00:00:00
CODE | NAME | WEIGHT | WEIGHT | WEIGHT | GROWTH RATE | GROWTH RATE | GROWTH RATE | CONTRIBUTION | CONTRIBUTION | CONTRIBUTION | VALUE | VALUE |  |  |  |  | VALUE | PRICE | PRICE | PRICE
AAA | PRODUCT AAA | 40 | 12 | 23 | -2.435316834477169 | -0.8281271418122262 | -2.722711364911723 | -0.9741267337908678 | -0.09937525701746715 | -0.6262236139296963 | 100 | 80 |  |  |  |  | 60 | 1 | 5 | 9
BBB | PRODUCT BBB | 30 | 35 | 17 | -4.90380850438732 | 2.224387826047646 | 4.402034191476471 | -1.471142551316196 | 0.7785357391166762 | 0.7483458125510001 | 200 | 180 |  |  |  |  | 160 | 2 | 6 | 10
CCC | PRODUCT CCC | 15 | 45 | 48 | 2.375646414033097 | -4.258124387349414 | -1.978702210579 | 0.3563469621049646 | -1.916155974307236 | -0.9497770610779198 | 300 | 280 |  |  |  |  | 260 | 3 | 7 | 11
DDD | PRODUCT DDD | 15 | 8 | 12 | -1.346001269098974 | 2.498535609543886 | 0.139183936794451 | -0.2019001903648462 | 0.1998828487635109 | 0.01670207241533411 | 400 | 380 |  |  |  |  | 360 | 4 | 8 | 12
TOTAL |  | 100 | 100 | 100 | -2.290822513366946 | -1.037112643444517 | -0.8109527900412818 | -2.290822513366946 | -1.037112643444517 | -0.8109527900412818 | 1000 | 920 |  |  |  |  | 840
CODE | NAME | 1/1/2025:WEIGHT | 1/2/2025:WEIGHT | 1/3/2025:WEIGHT | 1/1/2025:GROWTH RATE | 1/1/2025:CONTRIBUTION | 1/1/2025:VALUE | 1/1/2025:PRICE | 1/2/2025:GROWTH RATE | 1/2/2025:CONTRIBUTION | 1/2/2025:VALUE | 1/2/2025:PRICE | 1/3/2025:GROWTH RATE | 1/3/2025:CONTRIBUTION | 1/3/2025:VALUE | 1/3/2025:PRICE
AAA | PRODUCT AAA | 40 | 12 | 23 | -2.435316834477169 | -0.9741267337908678 | 100 | 1 | -0.8281271418122262 | -0.09937525701746715 | 80 | 5 | -2.722711364911723 | -0.6262236139296963 | 60 | 9
BBB | PRODUCT BBB | 30 | 35 | 17 | -4.90380850438732 | -1.471142551316196 | 200 | 2 | 2.224387826047646 | 0.7785357391166762 | 180 | 6 | 4.402034191476471 | 0.7483458125510001 | 160 | 10
CCC | PRODUCT CCC | 15 | 45 | 48 | 2.375646414033097 | 0.3563469621049646 | 300 | 3 | -4.258124387349414 | -1.916155974307236 | 280 | 7 | -1.978702210579 | -0.9497770610779198 | 260 | 11
DDD | PRODUCT DDD | 15 | 8 | 12 | -1.346001269098974 | -0.2019001903648462 | 400 | 4 | 2.498535609543886 | 0.1998828487635109 | 380 | 8 | 0.139183936794451 | 0.01670207241533411 | 360 | 12