Sorting similar entries from one column, into respective rows

[Captain Awol]

Hey so I posted this question a few hours ago, but somehow I managed to mark it as solved and it got 0 replies. Sorry if I messed something up!

I have a very large spreadsheet with data formatted like this: http://prntscr.com/1nkcu9

I want to take all the entries that are similar (only different by numbering) and put them on the same row, like this: http://prntscr.com/1nkgid
but I can't find any guides that explain how to do anything similar to this. I'm not great at VBA and I haven't been able to figure out any way to do it using regular formulas because there are different numbers of URLs for each grouping and I'm not sure how to iterate it properly.

I actually posted this question before (on the excel subreddit) and I got some useful looking, but non functional, VBA, and the guy never responded to my follow up.

Any advice is much appreciated!

Here's the VBA I have btw:

Please Login or Register  to view this content.

Here's what my data actually looks like:

10dollarwholesale.org/Product%20Images/1-DAY%20PILL%20REMINDER.JPG
10dollarwholesale.org/Product%20Images/1-DAY%20PILL%20REMINDER_1.JPG
10dollarwholesale.org/Product%20Images/1-DAY%20PILL%20REMINDER_2.JPG
10dollarwholesale.org/Product%20Images/2PK%20MOUSE%20TRAPS.JPG
10dollarwholesale.org/Product%20Images/2PK%20MOUSE%20TRAPS_1.JPG
10dollarwholesale.org/Product%20Images/2PK%20MOUSE%20TRAPS_2.JPG
10dollarwholesale.org/Product%20Images/2PK%20MOUSE%20TRAPS_3.JPG
10dollarwholesale.org/Product%20Images/2TSP.%20ORAL%20SYRINGE.JPG
10dollarwholesale.org/Product%20Images/2TSP.%20ORAL%20SYRINGE_1.JPG
10dollarwholesale.org/Product%20Images/2TSP.%20ORAL%20SYRINGE_2.JPG
10dollarwholesale.org/Product%20Images/3IN1%20TRAVEL%20CRKSCRW.JPG
10dollarwholesale.org/Product%20Images/3IN1%20TRAVEL%20CRKSCRW_1.JPG
10dollarwholesale.org/Product%20Images/3IN1%20TRAVEL%20CRKSCRW_2.JPG
10dollarwholesale.org/Product%20Images/3IN1%20TRAVEL%20CRKSCRW_3.JPG
10dollarwholesale.org/Product%20Images/3IN1%20TRAVEL%20CRKSCRW_4.JPG

And here's essentially what I want to do:

A1
A2
A3
A4
B1
B2
C1
C2
C3
D1
D2
E1
E2
E3
E4
E5

A1 A2 A3 A4
B1 B2
C1 C2 C3
D1 D2
E1 E2 E3 E4 E5

[GC Excel]

Hi and welcome to the forum,
Can't see the images you posted...
It would be easier if you could put a sample workbook with few lines with current / expected results.

[Captain Awol]

Hey, thanks for the reply. I just added data too my post as well as attaching the spreadsheet, I hope that's more clear.

[GC Excel]

Hi,
Here's a code to try. Results will be copy in the 3rd sheet. Adapt as required.
You may have some exceptions not captured by the macro.

Please Login or Register  to view this content.

[Captain Awol]

Holy Cow, that is exactly what I needed and it works perfectly! Thank you so much that makes my life 1000x easier! You're the best GC Excel!!

PS I know a bit of VBA and I can't figure out how this works at all, if you want to take a second to explain it that would be awesome, if not, no worries!!

Thanks Again!

[GC Excel]

Hi,
I've added some comments to the code for your understanding :

Please Login or Register  to view this content.