Need to add duplicates in a format

[abbas99]

I have 2 sheets that i need to merge into one but the format is not as simple so it cannot be just copy pasted. But i feel there will be a way to do that with a vba. Hoping to get a solution from here.


here is what I am looking to do. First column is "Source URL" and Second column is "URL". Both of them have exact same url's. I have highlighted them in colors for a better understanding. I want to duplicate "Column B to Column O" according to "Column A" Format. Any solution is very appreciated.


Screenshot is attached below for better understanding of problem.

 

[Fluff]

Cross posted.
Cross-Posting
While we do not prohibit Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules).
This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.

Please supply links to all sites where you have posted this question.
Thanks

 

[abbas99]

Cross posted.
Cross-Posting
While we do not prohibit Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules).
This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.

Please supply links to all sites where you have posted this question.
Thanks

Sorry I was not aware of that rule. Not regular at posting on forums. Have posted the same question on Stackoverflow and Excelforum. Have deleted the stackoverflow question already. you can mark this as solved or delete the post as I am getting replies on excelforum. Thanks for letting me know about the rule. I will make sure to comply with the rule when posting a thread next time. THanks