Excel Data Manipulation - NEED HELP AIUTOOO

[hurmet.noka]

Hello guys.
I have a delicate problem here.
I have that Excel as attached and I want a result like the one in the picure.
Problem is the second and third column cells are now separate rows but everything is in one place. How can I split it and build a nice datatable as shown in the picture.
When i try to split it returns a single value still.
How can we tackle this?

Thank you so much

Software Versions_20221024_094903.xlsx (11.2 KB)

[Nicolae_Alin_Savu (Nicolae Savu)]

Hi,

Please find attached my solution. I don’t know if it is the most understandable or the fastest, but at least is doing the job. Starting from the scenario that on column B & C you have the same amount of values ( i mean words one under another ) the solution creates a datatable which have first 3 values predefined as in your example, and the other can be added just adding a new value in the datatable format ( Build Data Table function )

Press on “+” button and add at the end what column you want, or delete some of them, just keep the first 3. After that, you need to go into the variables Panel at “output_array_Columns_Name” and add in that list any other values from B that you want to be as column in the next datatable

and then everything will be put into the datatable

Don’t forget to instantiate Input File / Output File.

Hope it helps you this solution,
Alin

Code Below,
Excel_DataManipulation.zip (5.0 KB)

[hurmet.noka]

Man, you an absolute genius.
Thank you so much.
Its perfect.

Wish you all the best my friend.
Thank you