Merging data while deleting duplicates?

**kosmoscake** · 11-16-2012, 02:10 PM

So I've looked through the entire forum looking for this macro or possible formula. I saw many situations that were SIMILAR to mine but when attempting to use the macros they either came up with an error or ... did not work the way they should have (they deleted corresponding data is column B after deleting duplicate data in Column A, etc.)

I have attached the file in question.

I would like the below list to go from This:
Store A URL1
Store A URL2
Store A URL3
Store B URL4
Store B URL5
Store C URL6

To This:
Store A URL1, URL2, URL3
Store B URL4, URL5
Store C URL 6

Please let me know if that makes sense when coupled with the Attachment. THANK YOU!!

**arlu1201** · 11-16-2012, 02:13 PM

In the output, do you want the URLs to be in the same columns or in multiple columns?

**kosmoscake** · 11-16-2012, 02:24 PM

The URLs for each Store# should be in the same column separated by a comma if possible.

**arlu1201** · 11-16-2012, 02:31 PM

Try this

Please Login or Register  to view this content.

**kosmoscake** · 11-16-2012, 02:32 PM

That worked for many but left many out (212, 213 for example.) See attachment ... What do I need to read to learn how to create macros like that?? Thank you so much.... xxto learn how to create macros like that?? Thank you so much.... xx

**arlu1201** · 11-16-2012, 02:34 PM

Just practice a few codes from this subforum and you will learn

Based on your last post in this thread, its apparent that you are satisfied with the solution(s) you've received and have solved your question, but you haven't marked your thread as "SOLVED". I will do it for you this time.

In future, to mark your thread as Solved, you can do the following -
Select Thread Tools-> Mark thread as Solved.

Incase your issue is not solved, you can undo it as follows -
Select Thread Tools-> Mark thread as Unsolved.

Also, since you are relatively new to the forum, i would like to inform you that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post which helped you. This adds to the reputation of the person who has taken the time to help you.

**kosmoscake** · 11-16-2012, 02:37 PM

There were some missed out (212, 213, 285)

**kosmoscake** · 11-16-2012, 02:48 PM

Okay- so I ran the macro a couple of times. The length of the document was such that it required the macro to be run more than once in order to reconcile any remaining variables. Thank you so much!!