Hello
I have been trying to solve this for 3 days but cant get anywhere with it, the id number can be different but same value 331, 0331 but all the names are the exact same.
ID |
name |
website |
email |
Phone |
package |
cat_i |
650 |
Next inc |
www."".com |
aa@"".com |
111 |
TLI10 |
201 |
650 |
Next inc |
www."".com |
aa@"".com |
111 |
AER |
151 |
31 |
NEXUS |
www."".com |
aa@"".com |
222 |
AER |
151 |
031 |
NEXUS |
www."".com |
aa@"".com |
222 |
AEC |
425 |
031 |
JUST CORP |
www."".com |
aa@"".com |
333 |
TLI10 |
201 |
15496 |
ACME inc |
www."".com |
aa@"".com |
444 |
TLI10 |
201 |
15496 |
ACME inc |
www."".com |
aa@"".com |
444 |
RMS |
245 |
15496 |
ACME inc |
www."".com |
aa@"".com |
444 |
AEC |
425 |
i need to run a macro to change it to
ID |
name |
website |
email |
Phone |
package |
cat_i |
650 |
Next inc |
www."".com |
aa@"".com |
111 |
TLI10, AER |
201,151 |
31 |
NEXUS |
www."".com |
aa@"".com |
222 |
AER, AEC |
151, 425 |
031 |
JUST CORP |
www."".com |
aa@"".com |
333 |
TLI10 |
201 |
15496 |
ACME inc |
www."".com |
aa@"".com |
444 |
TLI10, RMS, AEC |
201, 245, 425 |
Please help if you can i have 18000 rows and i have been manualy doing data entry and have only got 2000 rows done this will take me weeks to do. i found the below but i can not work out how to change it to work with this.
Bookmarks