A
ATanker62
Hello all,
Here is my problem, large data set I have already organized it by state,
city, outergroup number.
AC AH AI BJ
188007 Williams IA 50
188007 Williams IA 126.851
180007 Belgrade MT 110
188111 Russelvile AR 70.014
188111 Texakana AR 169.001
188111 Barstow CA 60.006
188111 Barstow CA 50.108
What I want to do is the following
Insert a blank line between different cities, then a subtotal by the city,
then a total by the group number.
Data to look like this after work is done
AC AH AI BJ
188007 Williams IA 50
188007 Williams IA 126.851
176.851
180007 Belgrade MT 110
110.00
276.851
188111 Russelvile AR 70.014
70.014
188111 Texakana AR 169.001
169.001
188111 Barstow CA 60.006
188111 Barstow CA 50.108
110.108
349.123
Thanks
Here is my problem, large data set I have already organized it by state,
city, outergroup number.
AC AH AI BJ
188007 Williams IA 50
188007 Williams IA 126.851
180007 Belgrade MT 110
188111 Russelvile AR 70.014
188111 Texakana AR 169.001
188111 Barstow CA 60.006
188111 Barstow CA 50.108
What I want to do is the following
Insert a blank line between different cities, then a subtotal by the city,
then a total by the group number.
Data to look like this after work is done
AC AH AI BJ
188007 Williams IA 50
188007 Williams IA 126.851
176.851
180007 Belgrade MT 110
110.00
276.851
188111 Russelvile AR 70.014
70.014
188111 Texakana AR 169.001
169.001
188111 Barstow CA 60.006
188111 Barstow CA 50.108
110.108
349.123
Thanks