Sample-2015-11-07-Transpose_files
"Cash Register Data (bar codes, etc..)"
"Register to EXCEL"
"Daily Sales Activity"
"Yr to Date Sales"
"Lic & Utility Cost"
"Vendor Cost"
"Mini BarCode Service"
"Home/Start Page"
E-mail : Roger@rogerward.com For More Information!

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
"Cash Register Data (bar codes, etc..)"
"Register to EXCEL"
"Daily Sales Activity"
"Yr to Date Sales"
"Lic & Utility Cost"
"Vendor Cost"
"Mini BarCode Service"
"Home/Start Page"
E-mail : Roger@rogerward.com For More Information!