Concatenate and Combine numbers.

[serge]

Hi everyone,

I'm asking for 2 formulas in this same post because it's linked together otherwise let me know and I will start a second tread for the second one, Thank ou all for any help.

The first formulas need to start in K3, across and down, that will combine C3:E7 with G3:I7 which should return the results in K3:P7 ( in yellow ).

The second formula need to combine the numbers in K3:P7 in sets of 5 numbers, which the return are in R3:V15 ( Blue )

 

[Bo_Ry]

Thanks to Eric's great formulas.
Here is my version

Book2
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y
1
2
3			5	6	7		2	4	0		52	54	62	64	72	74					52	84	75	67	35
4			8	0	0		4	0	0		84										52	84	75	97	35
5			7	0	0		5	0	0		75										54	84	75	67	35
6			6	9	0		7	0	0		67	97									54	84	75	97	35
7			3	0	0		5	0	0		35										62	84	75	67	35
8																					62	84	75	97	35
9																					64	84	75	67	35
10																					64	84	75	97	35
11																					72	84	75	67	35
12																					72	84	75	97	35
13																					74	84	75	67	35
14																					74	84	75	97	35
15
16
17
Sheet2

Cell Formulas
Range	Formula
K3:S7	K3	=IFERROR(SMALL(IF($C3:$E3*TRANSPOSE($G3:$I3),$C3:$E3*10+TRANSPOSE($G3:$I3)),COLUMNS($K3:K3)),"")
U3:Y17	U3	=IF(ROWS(U$3:U3)>PRODUCT(MMULT(N($K$3:$S$7<""),ROW($U$3:$U$11)^0)),"",INDEX($K$3:$S$7,COLUMNS($U3:U3),MOD((ROWS(U$3:U3)-1)/MAX(1,PRODUCT(MMULT(N(INDEX($K$3:$K$8,COLUMNS($U3:U3)+1):$S$7<""),ROW($U$3:$U$11)^0))),COUNT(INDEX($K$3:$S$7,COLUMNS($U3:U3),)))+1))

 

[Eric W]

Thanks to Eric's great formulas.
Here is my version

Nice! I always get a kick when people collaborate and throw out ideas, and modify, and adapt, and get something that is better than any individual offering. One thought: the K3 formula here requires that the values in C:E and G:I be in ascending order. That's the case in this example, so that's probably ok.