Insert Rows

[supermanPunch (Arpan)]

@Chendoran_M ,

Could you check with the below Steps and Implementation :

1. Read the excel sheet as a Datatable using Read Range Activity. Create the Output Datatable schema by cloning the Input datatable. Next, as we would require to convert certain column data to rows, store those column names in an array. An Image representation is shown below :
   

   

2. Next, Loop through the Input datatable using For Each Row Activity. Inside the For Each Row, use Add Data Row Activity and Add the First row to the Output Datatable as shown in the image below. The ArrayRow Expression uses the First 3 Column data as it is and then appends empty values to the next column data until the Status Column. Then the Status Column data is appended to it.
   

   

3. Next, Adding/Converting of the column data to rows is done using a For Each Loop. We use the column names stored to access the values one by one and use Add Data Row Activity to add the column values as row data. Since we only need the Prod_Id_* column data we can keep the other columns as Empty data.
   

4. We can then write the OutputDT value to an Excel sheet using Write Range Activity.
   

Check the workflow below :
Excel_SplitRows_ToMultipleRows.zip (10.0 KB)