Find in column A Name, Go to cell x Enter the formula and repeat. The title and formula continue to change.

[Slavio]

There are 4 tables below each other in the sheet. Each has a header and a variable number of rows
The search is always in column A.

1. The table has a header named "Name1" in column A. Find Name1.
Then enter the formula according to cell G1 in cell F1. Then FillDown until Name1 changes to Name2 in Column A.

2. Find Name2. Then enter the formula according to cell G2 in the cell in column F. Then FillDown until Name2 changes to Name3 in Column A.

3. Find Name3. Then enter the formula according to cell G3 in the cell in column F. Then FillDown until Name3 changes to Name4 in Column A.

4. Find Name4. Then enter the formula according to cell G4 in the cell in column F. Then FillDown to the last line.

Where do I start?

A	B	C.	D	JE	F	G
Name1	BBB	CDF	automatic		= CONCATENATE (A1; B1; C1; D1)	= CONCATENATE (A1; B1; C1; D1)
25645	6564	6564	331		= CONCATENATE (A1; B1; C1; D1)	= CONCATENATE(A4; B8)
Name2	Ahoj	hu			= CONCATENATE (A4; B8)	= (C2-D5)
456	636	32,65			= CONCATENATE (A4; B8)	= (A2 + A4)
123	13,52	5			= CONCATENATE (A4; B8)
Name3	Uzb	Antony	Panoli		= (C2-D5)
32.35	0	89	65,52		= (C2-D5)
Name4	KUKUK	Zbra	Kurol		= (A2 + A4)
456	32.89	0,236	7		= (A2 + A4)