I'm looking for a formula (not a macro) to covert multiple records for a particular company into one row. I actually have over 3000 records but the below sample example gives you an idea of data ..
What I have now..
Organisation Department Funding
Red A $100,000.00
Red B $200,000.00
Red C $150.00
Red D $0.00
Blue A $5,000.00
Blue B $10,000.00
Blue C $750,000.00
Blue D $5,000.00
What I need
Organisation Funding_A Funding_B Funding_C Funding_D
Red $100,000.00 $200,000.00 $150.00 $0.00
Blue $5,000.00 $10,000.00 $750,000.00 $5,000.00
Many thanks for any assistance you can provide.