Grouping similar numbers in a row

I have 1500 product image names consisting of 7 digits each in one Excel column. The first numbers of each code indicates the product and the last 2 only the colour.

Some of the codes have corresponding numbers (first 5) in 2 or more lines. I would like to know if there is a formula that will recognize the corresponding first 5 numbers for a number of rows and then be able to place all these corresponding numbers' full file name in one row?

For Example:

This is the list of product image names I have.

1107000.jpg
1107004.jpg
1107005.jpg
1108500.jpg
1108503.jpg
1108504.jpg
1108505.jpg
1108509.jpg
1108510.jpg
1108511.jpg

Once the formula is applied by recognizing the first five corresponding numbers it should be place in one line as follows:

1107000.jpg1107004.jpg1107005.jpg
1108500.jpg1108503.jpg1108504.jpg1108505.jpg1108509.jpg1108510.jpg1108511.jpg

At this stage I do this exercise manually which takes up a lot of time.

I would really appreciate some help!

Brilliant!

It does the job! Just one question.

In the formatted sheet, if you want the file names all in one row in a column instead of over various columns. Is that possible?

Hi!

Works like a bomb, thanks!

Last question, I hope!

Now that the file names are all in one line what can I do to now choose the product lines with the most images in as the default line and carry that row over to a spreadsheet instead of once again doing it manually?

Hi Marvin,

It looks like this is the solution I am looking for.

But how do I expand the Helper table to include all the product codes and to give the corresponding max number of helpers?

I posted a similar problem previously but this one has a twist.

I have 3 500 product image names consisting of anything from 5 to 9 digits each in one Excel column. The product codes contain both letters and numbers

I would like to know if there is a formula that will recognize the corresponding first numbers for a number of rows and then be able to place all these corresponding numbers' full file name in one row?

For Example:

This is the list of product image names I have.

BB07000.jpg
BB07004.jpg
BB07005.jpg
CC08500.jpg
CC08503.jpg
CC08504.jpg
CC08505.jpg
CC08509.jpg
CC08510.jpg
CC08511.jpg

Once the formula is applied by recognizing the first five corresponding numbers it should be place in one line as follows:

BB07000.jpgBB07004.jpgBB07005.jpg
CC08500.jpgCC08503.jpgCC08504.jpgCC08505.jpgCC08509.jpgCC08510.jpgCC08511.jpg

At this stage I do this exercise manually which takes up a lot of time.

I am attaching a sample of the numbers which need to be grouped.

I would really appreciate some help!