Hi all,
I have existing data on the left. I need the outcome shows on right? Not sure how to derive it. Can you guys pls help me out? Thanks!
<colgroup><col><col span="2"><col><col span="3"><col><col><col><col><col><col><col span="4"></colgroup><tbody>
</tbody>
I have existing data on the left. I need the outcome shows on right? Not sure how to derive it. Can you guys pls help me out? Thanks!
A | B | C | D | E | F | A | B | C | D | E | ||||||
1 | Date | GL | Description | SouthAsia | NorthAsia | Europe | 1 | Location | SouthAsia | |||||||
2 | Jan18 | 1111 | Sales | 2000 | 3000 | 4000 | 2 | |||||||||
3 | Jan18 | 1112 | Exp | 1000 | 1500 | 2000 | to | 3 | GL | Description | Jan18 | Feb18 | ||||
4 | Jan18 | 1113 | Net Sales | 1000 | 1500 | 2000 | 4 | 1111 | Sales | 2000 | 3000 | |||||
5 | Feb18 | 1111 | Sales | 3000 | 4000 | 5000 | 5 | 1112 | Exp | 1000 | 1500 | |||||
6 | Feb18 | 1112 | Exp | 1500 | 2000 | 3500 | 6 | 1113 | Net Sales | 1000 | 1500 | |||||
7 | Feb18 | 1113 | Net Sales | 1500 | 2000 | 1500 | ||||||||||
<colgroup><col><col span="2"><col><col span="3"><col><col><col><col><col><col><col span="4"></colgroup><tbody>
</tbody>