I have products in my rows and year/month in my columns
Now i would like to show multiple values horizontally for each product/month.
So in this case i have 4 values, is it possible to get it like this:
So each row is one of the values.
Now i would like to show multiple values horizontally for each product/month.
So in this case i have 4 values, is it possible to get it like this:
So each row is one of the values.
| January | February | |
| |||
| |||
| |||
|
ForecastMP (3).xlsx | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | |||
2 | |||||||||||
3 | Year | Month Name | Values | ||||||||
4 | 2019 | 2019 | 2019 | 2019 | 2019 | 2019 | 2019 | 2019 | |||
5 | January | January | January | January | February | February | February | February | |||
6 | Product Code | Sum of Quantity | Sum of Freight Costs | Sum of Sales Costs Var. | Sum of Sales | Sum of Quantity | Sum of Freight Costs | Sum of Sales Costs Var. | Sum of Sales | ||
7 | 435345 | ||||||||||
8 | 37567 | 36 | 0 | 0 | 14,76 | 360 | 0 | 1,15 | 144,7 | ||
9 | 5687568 | ||||||||||
10 | 6345856 | 2050 | 0 | 2,19 | 794,5 | 2970 | 0 | 5,07 | 1161,3 | ||
11 | 546 | 300 | 0 | 0 | 51 | 180 | 0 | 0,93 | 46,8 | ||
12 | 85689 | 19200 | 0 | 0 | 2688 | ||||||
13 | 67458 | ||||||||||
14 | 7956 | 1049 | 0 | 250,39 | 1653,23 | 737 | 0 | 360,44 | 1435,69 | ||
15 | 5688578 | 180 | 0 | 0 | 245,2 | 130 | 0 | 0,3 | 181,9 | ||
16 | 588958586 | 102 | 0 | 28,75 | 292,62 | 188 | 0 | 66,08 | 596,9 | ||
Sheet2 |