Need help getting data from multiple columns based of specific row information in SQL Query
===

Hi I need help getting data from multiple columns based of specific row information (Blue and Red), then returning different columns for each of the row criteria.

example :


    ID |  Code Type  | Code
    1  |  Blue       | Blue1XX
    2  |  Red        | Red1XX
    2  |  Blue       | Blue1XX
    3  |  Red        | Red1XX
    4  |  Blue       | Blue1XX
    4  |  Red        | Red1XX
    5  |  Blue       | Blue1XX


I need to return

    ID | Blue     | Red   
    1  | Blue1XX  |        
    2  | Blue1XX  | Red1XX
    3  |          | Red1XX
    4  | Blue1XX  | Red1XX
    5  | Blue1XX  |      

Blue always returns Blue1XX  (6 number code)
Red always returns Red1XX   (5 number code)

I will need to search with a specific string of ID's such as :

    AND ID IN (
    '1',
    '2',
    '3',
    '4',
    )

Any help would be appreciated. 