drag upper cell value from non contiguous cell until empty cell is found vba

[namariegaudi]

I have a table that looks like this (see below). I want to put in a new column the value that says "Nombre:XXXXXX" until a new value of "Nombre:" is found and then drag that new value intul I have a new column with names repeated. I know some names roll over to other columns and would need to concatenate those first

Nombre:DETERGENTE	LUBRO	CLEAN	387	LT
05/Sep/20A	1,025	Factura	0	0	0	10,656.00
09/Sep/20A	1,026	Factura	0	0	0	1,035.00
13/Sep/20A	1,027	Factura	0	0	0	11,576.00
20/Sep/20A	1,030	Factura	0	0	0	10,816.00
20/Sep/20A	1,031	Factura	0	0	0	10,816.00
27/Sep/20A	1,033	Factura	0	0	0	10,816.00
28/Sep/20A	1,036	Factura	0	0	0	6,000.00
30/Sep/20A	1,037	Factura	0	0	0	10,816.00
Nombre:LUBRO	RUST	OFF	PSM	LT
20/Sep/20A	1,031	Factura	0	0	0	400
27/Sep/20A	1,033	Factura	0	0	0	400
30/Sep/20A	1,037	Factura	0	0	0	400
Nombre:LUBRO	DL200/MX/TRN	LT
09/Sep/20A	1,026	Factura	0	0	0	11,000.00
20/Sep/20A	1,030	Factura	0	0	0	11,000.00
27/Sep/20A	1,033	Factura	0	0	0	6,000.00
28/Sep/20A	1,036	Factura	0	0	0	6,000.00
30/Sep/20A	1,037	Factura	0	0	0	9,000.00
Nombre:FLUIDO	SINTENTICO	LUBRO	SINT	55	LT
09/Sep/20A	1,026	Factura	0	0	0	800
28/Sep/20A	1,036	Factura	0	0	0	400
Total	Cliente	0	0	0	117,931.00
Nombre:	BARRILES	METALICOS	SA	DE	CV
Nombre:TAMBOR	VACIO	200	LT	PZA
30/Sep/20A	1,038	Factura	0	0	0	192

<colgroup><col><col span="4"><col><col></colgroup><tbody>
</tbody>