I have an excel sheet with 1000 rows. I want to insert 9 rows below every row and I also need to transpose selected column data to the newly added row. Any idea on how to do this using UiPath. I’ve tried adding new rows but its not added. Is this flow correct? [Screenshot 2022-12-15 114837]

@Chendoran_M , A similar logic that was applied to the previous input data could be also applied to this new data. Here, we would need to understand the number of columns that would be available for one column data, i.e in the data we have the column A_MM_ repeated 4 times indicated by the suffix n…

Insert Rows

Help Studio

Chendoran_M (Chendoran M) December 15, 2022, 6:53am 3

InputData.xlsx (9.6 KB)

Topic		Replies	Views
Transpose column data to row Studio excel , studio , question , activities_panel	1	649	December 17, 2022
Insert two blank rows after every row and copy paste columns Activities excel , question	5	817	June 6, 2023
Transpose the excel sheet data Studio activities , studio	7	1227	August 26, 2022
Transposing in Excel without any extensions Studio studio , question , activities_panel	9	525	June 7, 2023
How to transpose column to row Studio uiautomation	3	909	October 25, 2022

Insert Rows

Related topics