Heres what Im trying to do
from this...
Route BP Service Company City Total M-F Total Sat
HB3A010 83541 Apple New York 5 5
HB3A010 83541 Apple Detroit 5
HB3B002 83541 Apple Chicago 3 3
HB3B002 83541 Apple Dallas 3 3
HB3B008 83541 Apple Atlanta 7 7
HB3B008 83541 Apple Seattle 9 2
to this......
Route BP Service Company City Total M-F Total Sat
HB3A010 83541 Apple New York / Detroit 5 10
HB3B002 83541 Apple Chicago / Dallas 6 6
HB3B008 83541 Apple Atlanta / Seattle 16 9
I have a really long list, 4000+ records, im trying to get my excel sheet to look like the above,
some insight would really be appreciated
Bookmarks