Separate text need from not need it

[yobas]

Hi i have below information where have information that i do not need, for sample lines from 1 to 4 and what i need is only description in line 5 (the logic is for each empty cell i am going to need the above description, and put in another cell, so it is the same rule for all file ) i wonder if you can help me with some formula

Lines	sddd		COL1	Description
1	1		1	Servicios de importacion en USD
2	1		2	Servicios de importacion en USD - Se
3	1		3	Servicios de importacion en USD - Servic
4	1		4	Servicios de importacion en USD - Servicios
5	1		5	Servicios de importacion en USD - Servicios de impo
6	1
7	1		1	Servicio especializado de soporte tecnic
8	1		2	Servicio especializado de soporte tecnico par

[#2]

Hi @yobas

Does the attached file help?

[#3]

or this one (which references blanks on the next row)

[#4]

---

@Wyn Hopkins wrote:

or this one (which references blanks on the next row)

---

Thank you very much,

I attached a sample, Bold line is the one requiered, so i need to separe this line from the rest of the text (So later i can sort and get only thie required data)

1	COL1	Description
2	1	Servicios
3	2	Servicios de
4	3	Servicios de i
5	4	Servicios de im
6	5	Servicios de importacion
7
8	1	Servicio especializado
9	2	Servicio especializado de
10	3	Servicio especializado de s
11	4	Servicio especializado de so
12	5	Servicio especializado de sopo
13	6	Servicio especializado de soport
14	7	Servicio especializado de soporte
15	8	Servicio especializado de soporte t
16	9	Servicio especializado de soporte te
17	10	Servicio especializado de soporte tec
18	11	Servicio especializado de soporte tecni
19	12	Servicio especializado de soporte tecnic
20	13	Servicio especializado de soporte tecnico
21	14	Servicio especializado de soporte tecnico p
22	15	Servicio especializado de soporte tecnico pa
23	16	Servicio especializado de soporte tecnico par
24	17	Servicio especializado de soporte tecnico para
25
26	1	Tarjetas
27	2	Tarjetas d
28	3	Tarjetas de
29	4	Tarjetas de p
30	5	Tarjetas de pre
31	6	Tarjetas de pres
32	7	Tarjetas de prese
33	8	Tarjetas de presen
34	9	Tarjetas de presenta
35	10	Tarjetas de presentac
36	11	Tarjetas de presentaci
37	12	Tarjetas de presentacion
38
39	Etc
40

[#5]

Thank you, but in second group did not work

COL1		Formula
1	Servicios de importacion en USD - Servic
2	Servicios d
3	Servicios de importacion
4	Servicios de importacion e
5	Servicios de importacion	Servicios de importacion
1	Servicio especializado de soporte tecnic
2	Servicio especializado de soporte tecnico
3	Servicio especializado de soporte tecnico
4	Servicio especializado de soporte tecnico
5	Servicio especializado de soporte tecnico
6	Servicio especializado de soporte tecnico
7	Servicio especializado de soporte tecnico
8	Servicio especializado de soporte tecnico
9	Servicio especializado de soporte tecnico
10	Servicio especializado de soporte tecnico
11	Servicio especializado de soporte tecnico
12	Servicio especializado de soporte tecnico
13	Servicio especializado de soporte tecnico
14	Servicio especializado de soporte tecnico
15	Servicio especializado de soporte tecnico
16	Servicio especializado de soporte tecnico
17	Servicio especializado de soporte tecnico	DOES NOT WORK HERE

[#6]

Did you copy the formula down? Are you able to attach the file or if not then a screenshot?

[#7]

Hello Wyn

Sure i did, i have attached the file with formula, it seems to be near of the solution, i think this formula require some adjusments or i am doing something wrong. Because it worked in the first group of data, but in the second not (It was un blank as well). Do you know why in the Second group of date it did not work ?

[#8]

Hi @yobas

The cell wasn't actually blank, there was a space there

So I've updated the formula to handle spaces too

[#9]

Hi Wyn

Excellent, thank you very much, it seems to worked, however, when i copy formula and paste as value, and i try to sort (To delete blank espaces)  it change the description to "#¿NOMBRE?" in another cells, even in description field as well, do you know how can. i fix this

[#10]

I note that the cells empty are not empty, putting a filter i see values like #¡REF¡ and  #¿NOMBRE?, how can i do that the "empty cells" will be really empty

[#11]

Can you attach a sample file please?

[#12]

Thank you

In second tab, is information without sort, the third is sorted, in column E i need to deleted blank spaces and leave only the ones with text