I have some strings that I need to turn it in columns in my CSV. I'm using Libreoffice Calc.
A important information is that some products don't have all attributes, so, if in the line that don't have the specific attribute, it needs to be blank.
My current values are in only one column, one per line, and are like this:
| A | B |
|---|---|
| fragile=No,lead_time=0 |
and I need to change to something like that:
| Attribute | fragile_value | lead_time_value |
|---|---|---|
| fragile | Yes | 1 |
| lead_time | No | 60 |
| color | 20 |
Which is the easiest way to do this?