I have a report that is generated in an output format that I need to change. I am running a financial detail report for 100 plus properties. The individual properties appear as column headers. The type of spend account appears in Column A. (See below) I need the data to be arranged as such - individual property to appear in column A - Spend account in Column B - Dollar amount in Column C. I need this repeated for every property on the report - all in A, B and C. (See below) Is there any way to do this?
<tbody>
</tbody>
<tbody>
</tbody>
ark | bno | bns | bnt | brr | |
Cleaning - Contract | 6,156.00 | 1,752.00 | 0.00 | 804.00 | 0.00 |
Cleaning - Supplies & Materials | 66.50 | 0.00 | 0.00 | 65.89 | 0.00 |
Cleaning - Mat Service | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
Cleaning - Other | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
HVAC - Contract | 8,388.24 | 6,771.12 | 1,347.12 | 1,519.44 | 456.96 |
HVAC - Supplies & Materials | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
HVAC - Other | 0.00 | 0.00 | 0.00 | 853.54 | 0.00 |
Other Refrigeration Equipment | 0.00 | 0.00 | 997.72 | 242.00 | 0.00 |
<tbody>
</tbody>
<tbody> </tbody> |
<tbody>
</tbody>