sales.xls | |||||||
---|---|---|---|---|---|---|---|

A | B | C | D | E | |||

1 | RegionTab | STORENUM | STORENAME | Sales | Region | ||

2 | Region1 | A | Jonesy1 | 1 | MD-A1 | ||

3 | Region1 | B | JonesyPlus1 | 3 | MD-A1 | ||

4 | Region1 | C | JonesySuperstore1 | 1 | MD-A1 | ||

5 | Region1 | D | JonesyCaf1 | 2 | MD-A1 | ||

6 | Region1 | E | JonesyBarandGrill1 | 2 | MD-A1 | ||

7 | Region2 | AA | Jonesy2 | 1 | MD-B1 | ||

8 | Region2 | AB | JonesyPlus2 | 1 | MD-B1 | ||

9 | Region2 | AC | JonesySuperstore2 | 1 | MD-B1 | ||

10 | Region2 | AD | JonesyCaf2 | 2 | MD-B1 | ||

11 | Region2 | AE | JonesyBarandGrill2 | 1 | MD-B1 | ||

12 | Region3 | BA | Jonesy3 | 1 | MD-C1 | ||

13 | Region3 | BB | JonesyPlus3 | 2 | MD-C1 | ||

14 | Region3 | BC | JonesySuperstore3 | 2 | MD-C1 | ||

15 | Region3 | BD | JonesyCaf3 | 1 | MD-C1 | ||

16 | Region3 | BE | JonesyBarandGrill3 | 1 | MD-C1 | ||

17 | Region4 | CA | Jonesy4 | 2 | MD-C4 | ||

18 | Region4 | CB | JonesyPlus4 | 1 | MD-C4 | ||

19 | Region4 | CC | JonesySuperstore4 | 1 | MD-C4 | ||

20 | Region4 | CD | JonesyCaf4 | 1 | MD-C4 | ||

21 | Region4 | CE | JonesyBarandGrill4 | 1 | MD-C4 | ||

Sheet1 |