Change table format from data in cell

[huynhduc]

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)

[iCFO]

How to split multiline cells

Hi @kowisoft, I’ve had a look and uploaded my proposed solution here: Multiline-Cells v4-Alex – KNIME Community Hub. I kept your workflow and added mine underneath. What I am doing: I split the table so that only the Sales columns go into the loop. The rest I split off and add later again. I add an ID column to keep track of which row something belongs to, because in-between I use Ungroup, which may generate multiple rows from one row. Then I loop through the sales columns and split each val…

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