Ways to deal with large amount of columns;

[a]

Hi all:


I need to make a table contains projected monthly cashflow for multiple agents 
(10,000 around).


Therefore, the column number would be 1000+. 


I would need to perform simple aggregate function such as count, sum or average 
on each cashflow projected.


So if there is anyway of doing this? Will there be anything like define a macro 
in C that I can manipulate multiple columns by simple word that representing 
them.


Thanks so much!


Shore