How to converts data column into data table

Hi all,

Please help me to convert below data column to data table Based on the empty values

datacolumn

Desired result should be as below
Datatable

Thanks in advance

Hi,

Hope the following sample helps you.

Sample20200221-1.zip (17.1 KB)

Regards,

1 Like

@Yoichi You beat me to it. Interesting way to do it with string manipulation! Here is the code I wrote, which uses the parity of the row number to determine where to write the cell.

Processusvierge.zip (20,5 Ko)

1 Like