Need to edit code to work with this spreadsheet please.

SOLTEC

Board Regular
Joined
Feb 11, 2015
Messages
195
Office Version
  1. 365
  2. 2019
Platform
  1. Windows
Sub ConcatImageGroups()
Dim LastRow As Long, Ar As Range
LastRow = Cells(Rows.Count, "M").End(xlUp).Row
Range("O2:O" & LastRow) = Evaluate("IF(M2:M" & LastRow & "=1,1,"""")")
For Each Ar In Range("O2:O" & LastRow).SpecialCells(xlBlanks).Areas
Ar(1).Offset(-1).Resize(Ar.Count + 1) = Join(Application.Transpose(Ar(1). _
Offset(-1, 1).Resize(Ar.Count + 1)), ";")
Next
End Sub


Excel 2010
ABC
1IDImagesCombination Images
246581000.jpg1000.jpg;1001.jpg;1002.jpg;1003.jpg;1004.jpg;1005.jpg;
346581001.jpg1000.jpg;1001.jpg;1002.jpg;1003.jpg;1004.jpg;1005.jpg;
446581002.jpg1000.jpg;1001.jpg;1002.jpg;1003.jpg;1004.jpg;1005.jpg;
546581004.jpg1000.jpg;1001.jpg;1002.jpg;1003.jpg;1004.jpg;1005.jpg;
646581005.jpg1000.jpg;1001.jpg;1002.jpg;1003.jpg;1004.jpg;1005.jpg;
747031024.jpg1024.jpg;1025.jpg;1026.jpg;
847031025.jpg1024.jpg;1025.jpg;1026.jpg;
947031026.jpg1024.jpg;1025.jpg;1026.jpg;
1049131031.jpg
1149131032.jpg
1249391035.jpg
1349391036.jpg
1449391037.jpg
1549391038.jpg
1650471045.jpg
1750471046.jpg
1850471047.jpg
1950471048.jpg
2050791051.jpg
2150791057.jpg
2250791058.jpg
2350791059.jpg
2451351060.jpg
2551351061.jpg
2651351062.jpg
2751351063.jpg
2851351064.jpg
2951351065.jpg
3051351066.jpg
3151351067.jpg
3251351070.jpg
3351351071.jpg
3451351072.jpg
3551351073.jpg
3651351074.jpg
3751351079.jpg
Sheet5


Thank you in advance for all assistance. It is greatly appreciated.
 

Excel 2010
ABC
446581000.jpg#NAME?
546581000.jpg#NAME?
646581000.jpg#NAME?
746581000.jpg#NAME?
846581000.jpg#NAME?
946581000.jpg#NAME?
1046581000.jpg#NAME?
1146581001.jpg#NAME?
1246581001.jpg#NAME?
1346581001.jpg#NAME?
1446581001.jpg#NAME?
1546581001.jpg#NAME?
1646581001.jpg#NAME?
1746581001.jpg#NAME?
1846581001.jpg#NAME?
1946581001.jpg#NAME?
2046581002.jpg#NAME?
2146581002.jpg#NAME?
2246581002.jpg#NAME?
2346581002.jpg#NAME?
2446581002.jpg#NAME?
2546581002.jpg#NAME?
2646581002.jpg#NAME?
2746581002.jpg#NAME?
2846581002.jpg#NAME?
2946581004.jpg#NAME?
3046581004.jpg#NAME?
3146581004.jpg#NAME?
3246581004.jpg#NAME?
Sheet2
Cell Formulas
RangeFormula
C1=CatIf(INDEX($A$2:$A$37=A2, 0), $B$2:$B$37, "; ")
C2=CatIf(INDEX($A$2:$A$37=A3, 0), $B$2:$B$37, "; ")
C3=CatIf(INDEX($A$2:$A$37=A4, 0), $B$2:$B$37, "; ")
C4=CatIf(INDEX($A$2:$A$37=A5, 0), $B$2:$B$37, "; ")
C5=CatIf(INDEX($A$2:$A$37=A6, 0), $B$2:$B$37, "; ")
C6=CatIf(INDEX($A$2:$A$37=A7, 0), $B$2:$B$37, "; ")
C7=CatIf(INDEX($A$2:$A$37=A8, 0), $B$2:$B$37, "; ")
C8=CatIf(INDEX($A$2:$A$37=A9, 0), $B$2:$B$37, "; ")
C9=CatIf(INDEX($A$2:$A$37=A10, 0), $B$2:$B$37, "; ")
C10=CatIf(INDEX($A$2:$A$37=A11, 0), $B$2:$B$37, "; ")
C11=CatIf(INDEX($A$2:$A$37=A12, 0), $B$2:$B$37, "; ")
C12=CatIf(INDEX($A$2:$A$37=A13, 0), $B$2:$B$37, "; ")
C13=CatIf(INDEX($A$2:$A$37=A14, 0), $B$2:$B$37, "; ")
C14=CatIf(INDEX($A$2:$A$37=A15, 0), $B$2:$B$37, "; ")
C15=CatIf(INDEX($A$2:$A$37=A16, 0), $B$2:$B$37, "; ")
C16=CatIf(INDEX($A$2:$A$37=A17, 0), $B$2:$B$37, "; ")
C17=CatIf(INDEX($A$2:$A$37=A18, 0), $B$2:$B$37, "; ")
C18=CatIf(INDEX($A$2:$A$37=A19, 0), $B$2:$B$37, "; ")
C19=CatIf(INDEX($A$2:$A$37=A20, 0), $B$2:$B$37, "; ")
C20=CatIf(INDEX($A$2:$A$37=A21, 0), $B$2:$B$37, "; ")
C21=CatIf(INDEX($A$2:$A$37=A22, 0), $B$2:$B$37, "; ")
C22=CatIf(INDEX($A$2:$A$37=A23, 0), $B$2:$B$37, "; ")
C23=CatIf(INDEX($A$2:$A$37=A24, 0), $B$2:$B$37, "; ")
C24=CatIf(INDEX($A$2:$A$37=A25, 0), $B$2:$B$37, "; ")
C25=CatIf(INDEX($A$2:$A$37=A26, 0), $B$2:$B$37, "; ")
C26=CatIf(INDEX($A$2:$A$37=A27, 0), $B$2:$B$37, "; ")
C27=CatIf(INDEX($A$2:$A$37=A28, 0), $B$2:$B$37, "; ")
C28=CatIf(INDEX($A$2:$A$37=A29, 0), $B$2:$B$37, "; ")
C29=CatIf(INDEX($A$2:$A$37=A30, 0), $B$2:$B$37, "; ")
C30=CatIf(INDEX($A$2:$A$37=A31, 0), $B$2:$B$37, "; ")
C31=CatIf(INDEX($A$2:$A$37=A32, 0), $B$2:$B$37, "; ")
C32=CatIf(INDEX($A$2:$A$37=A33, 0), $B$2:$B$37, "; ")


This is the results of the function run.
 
Upvote 0

Excel Facts

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.

Forum statistics

Threads
1,223,228
Messages
6,170,875
Members
452,363
Latest member
merico17

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top