How to combine a set number of cells into next column and continue down

[GratefullyDyed]

Hello,

I need to combine a list of photo links into a group as such:

The links need to be separated by a comma with no space.
The number of links per cell will remain the same, but depending on the product I will have a different number of photos I need to combine, so it needs to be easy enough to adjust the number it combines. For example:

Product1 formula would need to combine cells:

C1,C2,C3,C4
C5,C6,C7,C8
Etc...

Product2 might need:

C1,C2
C3,C4,
Etc...

Got a way good way to do this?

Thank you for your help!

 

[GratefullyDyed]

says right there so idk..

I'm on office 2021

 

[Fluff]

Ok, how about

Fluff.xlsm
	A	B	C	D
1			test 1	test 1, test 2, test 3, test 4
2			test 2	test 5, test 6, test 7, test 8
3			test 3	test 9, test 10, test 11, test 12
4			test 4	test 13, test 14, test 15, test 16
5			test 5	test 17, test 18, test 19, test 20
6			test 6
7			test 7
8			test 8
9			test 9
10			test 10
11			test 11
12			test 12
13			test 13
14			test 14
15			test 15
16			test 16
17			test 17
18			test 18
19			test 19
20			test 20
Data

Cell Formulas
Range	Formula
D1:D5	D1	=TEXTJOIN(", ",,INDEX($C$1:$C$20,ROWS(D$1:D1)*4-3):INDEX($C$1:$C$20,ROWS(D$1:D1)*4))

 

[GratefullyDyed]

Ok, how about

Fluff.xlsm
	A	B	C	D
1			test 1	test 1, test 2, test 3, test 4
2			test 2	test 5, test 6, test 7, test 8
3			test 3	test 9, test 10, test 11, test 12
4			test 4	test 13, test 14, test 15, test 16
5			test 5	test 17, test 18, test 19, test 20
6			test 6
7			test 7
8			test 8
9			test 9
10			test 10
11			test 11
12			test 12
13			test 13
14			test 14
15			test 15
16			test 16
17			test 17
18			test 18
19			test 19
20			test 20
Data

Cell Formulas
Range	Formula
D1:D5	D1	=TEXTJOIN(", ",,INDEX($C$1:$C$20,ROWS(D$1:D1)*4-3):INDEX($C$1:$C$20,ROWS(D$1:D1)*4))

That looks like it should work. This is the solution I am using.
=TEXTJOIN(",",,OFFSET(C$1,ROW()*4-4,,4))

Thank you for your help!

 

[Fluff]

Glad we could help & thanks for the feedback.