|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Copy a TEXT file & Paste Special
to COLs |
|
|
|
|
|
Select the $$ COLs copy, then Paste
Special Transpose |
|
|
to put in ROW that you want. NOTE: TAX amount is copied |
|
|
by it self ! Or put in
1st place. |
|
|
NUM |
DEPARTMENT |
TOTAL |
COUNT |
|
NUM |
DEPARTMENT |
|
NUM |
DEPARTMENT |
|
1 |
GROCERY |
$682.47 |
397 |
|
1 |
GROCERY |
|
201 |
TAX |
|
2 |
CIGARETTES |
$482.89 |
84 |
|
2 |
CIGARETTES |
|
1 |
GROCERY |
|
3 |
TOBACCO |
$212.45 |
59 |
|
3 |
TOBACCO |
|
2 |
CIGARETTES |
|
4 |
BEER |
$527.80 |
50 |
|
4 |
BEER |
|
3 |
TOBACCO |
|
5 |
WINE |
$11.97 |
3 |
|
5 |
WINE |
|
4 |
BEER |
|
6 |
DELI |
$875.77 |
371 |
|
6 |
DELI |
|
5 |
WINE |
|
7 |
DIESEL |
$224.57 |
10 |
|
7 |
DIESEL |
|
6 |
DELI |
|
8 |
GASOLINE |
$1,455.79 |
66 |
|
8 |
GASOLINE |
|
7 |
DIESEL |
|
9 |
ICE |
$22.96 |
14 |
|
9 |
ICE |
|
8 |
GASOLINE |
|
10 |
NEWSSTAND |
$17.00 |
14 |
|
10 |
NEWSSTAND |
|
9 |
ICE |
|
11 |
OIL |
$1.19 |
1 |
|
11 |
OIL |
|
10 |
NEWSSTAND |
|
12 |
PREMIUM |
$208.93 |
10 |
|
12 |
PREMIUM |
|
11 |
OIL |
|
13 |
MEAT |
$204.41 |
6 |
|
13 |
MEAT |
|
12 |
PREMIUM |
|
201 |
TAX |
$196.32 |
|
201 |
TAX |
|
13 |
MEAT |
|
|
|
|
|
NET |
$5,124.52 |
|
NET |
|
NET |
|
|
|
|
|
|
|
201 |
1 |
2 |
3 |
4 |
5 |
6 |
7 |
8 |
9 |
10 |
11 |
12 |
13 |
|
|
|
|
TAX |
GROCERY |
CIGARETTES |
TOBACCO |
BEER |
WINE |
DELI |
DIESEL |
GASOLINE |
ICE |
NEWSSTAND |
OIL |
PREMIUM |
MEAT |
|
|
|
|
|
|
|
|
$196.32 |
$682.47 |
$482.89 |
$212.45 |
$527.80 |
$11.97 |
$875.77 |
$224.57 |
$1,455.79 |
$22.96 |
$17.00 |
$1.19 |
$208.93 |
$204.41 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|