Hi for the sample table below in excel:
<tbody>
New York
Japan
China
Chicago
Product A
3
5
1
2
Product B
9
6
7
4
Product C
2
9
1
4
Product D
1
3
2
5
</tbody>
<tbody>
North America (New york &Chicago)
Asia(China&Japan
Product A
Product B
Product C&D
</tbody>
I have a...