Macro to list a multi-column sheet into unique rows

[ab11viva]

Hello,

I have a sheet that I'm working on that shows data with a unique ID and then anywhere from 1 to 12 columns of associated links/URLs. (see attached)


What I need to get to is a simple 2 column spreadsheet that would list ever unique ID and Link combination on a separate row.

So something like this...

ID Link1 Link2 Link3 Linkn
1 URL1 URL2 URL3 URLn

would become this...
ID Link
1 URL1
1 URL2
1 URL3
1 URLn

I've worked some with macros in the past but I am by no means experienced with them.

I'd appreciate any help you could provide.

Thanks

[natefarm]

This should do it. Add a Sheet2 first to receive the new data, then run the code.

Please Login or Register  to view this content.