Hi All,

I've a query data which has multiple entries in Column A and B and different
info in Columns C-H.

I'm trying to consolidate this data, but couldn't find a solution. Is there
any way to delete blank fields and reduce the number of rows. I've over
45,000 rows data.

A B C D E F G H
123 Zip EMP1
123 Zip EMP2
123 Last Name
123 Last Name EMP2 STAPLETON
112 ODS SC066 111208
112 ODS SC284
112 ODS
112 ODS SC176

I want the final data to look like this

A B C D E F G H
123 Zip EMP1 EMP2
123 Last Name EMP1 EMP2 STAPLETON
112 ODS SC284 SC176 SC066 111208


Thanks for your help in advance....
--
Karthi