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