Little bit lost!

I have duplicate data in column A however each relates to a part unique record. I need to get data from columns C - F & I for all the unique records in A. In the second pass i need the data from columns B,G,H for all the records in A

So I'm a little bit lost as to how I can do this.

Thanks in advance

Nick's picture

think this is a similar

think this is a similar post:
http://excelexperts.com/Vlookup-with-mulitple-column