parsing cells to column and cells

[hagay_finiti]

Hello,

I’m getting a csv file with one row , that has lots of cells in this format:
key=value that are seperated by the char “=” (e.g , key_a=value_a, key_b=value_b)
and i need to make the key as a header on new table and the value as the cell below.

files attached - input and the required output.

input.xlsx (8.8 KB)
output.xlsx (8.8 KB)

any suggestion?
thanks in advance.

[rfeigel]

Try this.
Parsing Cells to Column and Cells.knwf (125.1 KB)

[hagay_finiti]

Great solution.

Thank you @rfeigel.