Switching Columns to rows and Rows to columns

[Gareth Horton]

Here's a report snippet:
</BEGIN SNIP>
JOB: NN.NNN ------------JOB NAME----------
[-------------------------- COSTS -----------------------------]
MATERIAL SUBCONTRAC EQUIPMENT OTHER C.O.EQUIP

PHASE: MA

XXXX CONTINGENCY U.O.M:
ORIGINAL BUDGET 0 0 0 80000 0
REVISED BUDGET 0 0 0 85500 0
FORECAST 0 0 0 0 0
COMMITTED 0 0 0 0 0
INCURRED/INSTALLED 0 0 0 0 0
% COMPLETE .00 .00 .00 .00 .00
CCCP 0 0 0 0 0
ECAC 0 0 0 0 0
TO COMPLETE 0 0 0 0 0
</END SNIP>

I can capture the Job#, Job Name, Phase, PayCode (XXXX), and PayDesc (Contingency).
However, I need each of the Costs: Material, SubContrac, Equipment, Other, & C.O. Equip as rows to each job and the
rows: Original budget thru To Complete as the columns.
Will Monarch allow me to accomplish this?

Michael Jul Hansen wrote:
> Think you would be much better off dumping your report into Excel and then use pivot tables on it
>

Actually, since no one was using this list for such a long time, I had come up with a solution involving
summaries and it works perfectly. I would send a report/model, but unfortunately the info in the report is
confidential.