How to loop through cells?

Question

excel

Hello everyone, how can I implement cell enumeration?
There is a cell:

"Характеристики изделия|Вид карманов|Втачные и накладные 
Состав|Состав|75% хлопок, 20% полиэстер, 5% эластан   
Характеристики изделия|Назначение|Одежда повседневная, спорт
Характеристики изделия|Вид застежки|Застежка «молния»
Характеристики изделия|Посадка|Средняя
Характеристики изделия|Крой|Свободный
Цвет изделия|Цвет изделия|Черный, синий, серый
Характеристики изделия|Фактура материала|Трикотаж"

I need to figure out how to implement the script, give me an idea, and I need to sort by type
Name (for example: with jstav) Dimension (for example:%) and Value (for example 100% cotton)
Here's how I broke it with my hands:

Answer 1

Break it down and write it down in different cells in one line or several, it depends on the number of types of characteristics (Type of pockets, Purpose, Type of fastener, etc.)
But this can only be done with a macro
If everything is in one line, then I think there are no questions, but if different, then the
columns will be as follows - "Composition", "Color", Type of characteristic", Value of characteristic"