|
Pro's,
I might be posting this in the wrong list but I did not know where else to
post it so I apologize for that. I have a little situation and I was
wondering if any of you folks have some suggestions as to how could I go
about accomplishing this task. I have some files from which I am grabbing
the data and a part of the final data set is as follows..
***********************************************************************
STAT DIV TOTAL
=============
AL 01 538.84
AR 01 986242.07
FL 01 1832.98
GA 01 1783.61
IL 01 166.30
IN 01 756.67
KY 01 556.02
LA 01 1279787.24
MO 01 81.34
MS 01 9322.18
NC 01 88.33
NM 01 1323.00
NY 01 870.71
OK 01 196140.16
SC 01 1047.48
TN 01 192.99
TX 01 2152351.44
VA 01 35.45
AL 02 547497.96
AR 02 219.95
AZ 02 319.31
CO 02 20370.00
FL 02 58478.53
GA 02 242.04
IL 02 13376.24
KS 02 2524.62
KY 02 14114.40
LA 02 1685708.81
MO 02 27212.36
MS 02 1050836.64
NC 02 35543.00
NM 02 87.67
NY 02 14452.80
OK 02 7214.37
SC 02 7984.18
TN 02 29600.54
TX 02 130007.98
VA 02 40989.60
***************************
I am trying to create a report in MS Excel which would produce a spreadsheet
like below..
TOTAL AL AZ
AR CO FL...........................
01 4631379.05 538.84 974478.56
02 451586.72 451862.41 1563153.51
********************************************************************************************************
The above numbers are made up.....
I am thinking of associative arrays? Could it be done without involving
associative arrays? Any input/suggestions regarding this problem would be
much appreciated.
Thanks in advance,
cheers,
Jake.
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2025 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.