Convert table

[Shiva123]

Hi,
I need your help. I want to convert this table (Starting point to
Ending point).

I tried some simple manipulation nodes, but without success.
Can someone help me please?
Many greetings,
Shiva
table_transformation.knwf (8.0 KB)

[HansS]

Hi @Shiva123

See this wf table_transformation_2.knwf (74.9 KB). You only need to rename the Columns. And the column CompoundName is missing “:0”.

gr. Hans

[eamendola]

Hi @Shiva123
Here’s the solution I could come up for your task:

table_transformation_solution – eamendola

There is a little work with loops in order to make it work

Cheers

[Shiva123]

Hi @HansS and @eamendola,
thank you very much for your quick help! You have helped me a lot!
There is only one more problem, which was my mistake. I gave you a table where after all 14 rows the table starts again with “NAME:".
However, the table is actually much larger and it also happens very often that in the column the Rows are repeated arbitrarily. Sometimes after 14, sometimes after 16 or 20 … .
How can I solve the problem with the loops?
Is there any way to repeat the loop after all empty cells? Since there is an empty cell before each "Name:”…
I added a new table for you.
table_transformation2.knwf (6.5 KB)
Thanks for your help!
Many greetings,
Shiva

[morpheus]

Hi @Shiva123,

find attached my example how i would solve it.

BR

table_transformation example.knwf (23.0 KB)

[Shiva123]

Hi @morpheus,
it works. Thank you very much!
Greetings,
Shiva