Dear All,
I do have a sample data set from A1:D7 as follows:-
<tbody>
Region
Vertical
01-Dec
02-Dec
A
FMCG
10
12
A
FMCG
15
18
B
FMCG
20
16
B
Staples
25
29
C
Staples
30
38
C
FMCG
35
47
</tbody>
I would like to carry out the sum conditionally & the lay out is as follows spread...