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