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


Desired result should be as below

Thanks in advance


Hope the following sample helps you. (17.1 KB)


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. (20,5 Ko)

1 Like