I have data like this in a excel sheet (Columns A B C) [image] I have same column names in a transposed form like this in another excel sheet [image] What I need to do is compare and paste data into the transposed data sheet so final output should look like this [image]

[image] Ishan_Shelke: [image] Hi @Ishan_Shelke , Have you tried using the Transpose Datatable Activity ? [image] Novigo Solutions - Transpose DataTable - RPA Component | UiPath Marketplace |... Novigo Solutions - Transpose DataTable is an RPA component in the UiPath Marketplace ✔…

How to paste data according to column names in other sheet

Help Robot

Sudharsan_Ka (Sudharsan Ka) October 11, 2022, 6:55am 5

HI @Ishan_Shelke

Check this xaml file
Sample.xaml (12.6 KB)
demo.xlsx (8.4 KB)

Hope this Helps

Regards
Sudharsan

Topic		Replies	Views
Transposing in Excel without any extensions Studio studio , question , activities_panel	9	525	June 7, 2023
Transpose the excel sheet data Studio activities , studio	7	1227	August 26, 2022
How to transpose column to row in data table? Studio studio , question , activities_panel	4	5110	November 5, 2022
Transpose Datable Robot robot , question	5	1868	March 24, 2023
Tranpose columns to row in excel(C# code) Activities	1	848	May 19, 2021

How to paste data according to column names in other sheet

Related topics