I need to split array into row for each item

i need to convert sheet1 to be like sheet2 any help for that please?

@rpa13 ,

You can check the attached workflow, that will split the rows with the | symbol and add it to a new datatable as new rows. Then you can write that datatable into a new excel as per your need.
Split_DataRows.xaml (9.6 KB)

For Each Row in Data Table: Collection was modified; enumeration operation might not execute.
i got this error


Check the updated workflow.
Split_DataRows.xaml (15.3 KB)

1 Like

Main.xaml (10.1 KB)
Please check this…It’s working and easy to understand.Also, Please mark as solution if its working for you !!! Thank you !!

1 Like

thanks it work, but if i need to retun it back to be like this
154 10100856 500009893|500010000 1 | 2 1530|1526

You can GroupBy “Order_Num” and “Increment” columns

1 Like

okay i will try thank you very much dear

thank you very much

Please mark it as solution so that others can benefit if they face same issue in future.

1 Like

can i make condition insert first row and go to next row if the value in incremental_id reapeted insert the row if incremental_id change make action like (save)and go to next colom and so on any help please?

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.