Horizontal List of Items Sharing Same Information

[Treymaan]

I am trying to extract from a vertical list of Items that share the same Image URL to display the just one instance of the shared URL with all of the shared items listed horizontally.

So from the following data:

Image URL	ITEM
https://dms-systems.s3.us-east-2.amazonaws.com/bluewater/products/041604-1+(193x139).jpg	SEADOG0416041
https://dms-systems.s3.us-east-2.amazonaws.com/bluewater/products/041604-1+(193x139).jpg	SEADOG041606
https://dms-systems.s3.us-east-2.amazonaws.com/bluewater/products/041604-1+(193x139).jpg	SEADOG0416061
https://dms-systems.s3.us-east-2.amazonaws.com/bluewater/products/041604-1+(193x139).jpg	SEADOG0416081
https://dms-systems.s3.us-east-2.amazonaws.com/bluewater/products/041604-1+(193x139).jpg	SEADOG0416101
https://dms-systems.s3.us-east-2.amazonaws.com/bluewater/products/041604-1+(193x139).jpg	SEADOG041612
https://dms-systems.s3.us-east-2.amazonaws.com/bluewater/products/041604-1+(193x139).jpg	SEADOG0416121

I would like to generate one row that would have the following information in the Image URL column and ITEM column:

https://dms-systems.s3.us-east-2.amazonaws.com/bluewater/products/041604-1+(193x139).jpg

SEADOG041606,SEADOG0416061,SEADOG0416081,SEADOG0416101,SEADOG041612,SEADOG0416121

Would this type of operation be viable in VBA, and if so, how?

Thanks!

 

[Treymaan]

The example above was not what I intended to post. This screenshot shows what I intended.