Image URL downloader to file using Excel

I want to download the file from the URL links using Excel sheet. Here I attached the screenshot of the Excel sheet for the better understanding.

On column 2 there are some links differentiated by , comma. I need to split those and rename each image with the name provided in column 1 and add a suffix of 1 (Numbers) for first set and 2 for second set of images. It goes on until we complete the image set on columns.

Please help me creating a macro to download all this. Thanks for the help.