Formula Help - Urgent
 

I have info that looks like this:

AD0# Cost C D E F
A B A 6567 6568
6567 $2,200.00 B $2,200.00 $400.00 $400.00 $400.00
6568 $400.00 $2,200.00 $140.00
6988 $400.00
7999 $400.00

AD0# Cost
6567 $2,200.00
7999 $140.00


I would like to auto fill C,D,E,F with the info from column "A" only if it
is a unique # and have all the costs (column B) for that unique # line up
under it.
If a number from column "A" already exists in C-F, then I want just the
costs to autofill under the correct #.
I want to end having one column for each number with all costs for that #
under it. Make sense?
Any help with this one is appreciated.
DL