Convert multiple rows for a company to a single row

Hello,

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.

Cheers,

How do you want the results set out? in seperate columns?
How many colours are there? Does the data duplicate? ie is there more than 1 entry for RED A
might ne better attaching a workbook with a larger sample.
Probably you will need to set up a lot of formulas in each cell using the SUMIFS formula

Cheers
Sean

Hi Sean,

Data needs to be in separate columns. There are probably over 100 different colours (organisations).
For each organisation there are many departments that allocate funding. I basically need a new column for each departments funding.

I think TheExcelPhile just answered your problem!

sean

Cheers TheExcelPhile for your speedy reply .. you are one quick problem solver.

Thanks Sean too for your interest.

Hi TheExcelphile .. As I have over 100 different companies in my real data can I also populate the organisation from the formula?

sorry very new to this where to do you add files .. not sure if i have permissions to do so

Thanks ! Sample attached ...