Change table format from data in cell

Hi everyone,

I have the input like this:

I want to make a huge change in the format, I tried to split it but some how it doesn’t work.

This is the output I want.

I appreciate all your help.

Thank you very much.

EDIT: Outside KNIME, can it be done in excel guys?
draft test.xlsx (10.7 KB)

Take a look at this thread.

I always view the hidden return characters with online viewer sites like below first to pinpoint the specific Unicode line return.

https://www.soscisurvey.de/tools/view-chars.php

1 Like

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.