Moving data based on value to different columns.

[xoomoon]

hello,

I have data on the left column and would like to move them to the correct column.

For instance the value for b2=red and a2= the data for red and i want it to move it to column d2.

Is there a formula for this?
Also, is there a formula for a range so that cell d2 will contain all data based on a value within a range of cells?

Thanks

 

[sandy666]

You are welcome