I have a 1000 row spreadsheet with data in the following format that needs to be consolidated to a single row per company.  They are -not- duplicate rows that need to be deleted.

Company A               A            B            C

CompanyA                                                    D                 E        F

CompanyA                                                                                        G   H   I

CompanyB                 A             B           C     

CompanyB                                                      D                E         F

CompanyB                                                                                            G  H   I

....

etc

I need to collapse the rows to look like:

CompanyA            A         B      C      D      E     F     G     H   I

CompanyB            A         B      C      D      E     F     G     H   I

CompanyC           A         B      C      D      E     F     G     H   I

So, the goal is a single row per Company, with the mult rows of column values collapsed to the single row.

I do not feel this is a very good description of the issue, so please let me know if I can clarify it in any specific way.

I could also attach a file fragment if it would help explain it better.

Thanks in advance.