If and Vlookup across range in Excel

First time poster, long time user of the site. Essentially i need to work out for each unique ID(Column A), whether or not a "Y" exists in a set range of cells for that unique ID (Column $D). Some ID's are only there once (where i would just use a vlookup) but other ID's are repeated with different values in the return column.

Ideally i'd like the output sheet to look like Output sheet. Where each id is grouped (no duplicate id's).

[Raw Sheet][1]

[Output sheet][2]

Please let me know if i've structured this incorectly or any other feedback. Much appreciated,

Sam

![1]: http://ift.tt/1sznNJq ![2]: http://ift.tt/1WNi1Ap