K
Karthik
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....
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....