Separate text need from not need it
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