I don't know if anyone uses Argus here (its a real estate program) but I am trying to take the data dump from Argus and load it into a readable excel format. I can export all the data and get it to excel, but can't figure out how to format this.

Basically, the Argus dump lists all tenants in a building and money spent by the landlord (me) each by month to fix up their space:

Jan Feb March
Tenant A $100 $0 $25
Tenant B $0 $50 $100


Now I want to convert this into a format that lists:

January
$100 Tenant A

Feb
$50 Tenant B

March
$25 Tenant A
$100 Tenant B

We have sometimes over 100 tenants in a building and the months change all the time so I need a standard dump page and then a page that lists each tenant dollar amt spent by month. I only want it to grab the tenants name and dollar amt if its greater than zero.

Thanks