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

muhamed_fasil (muhamed fasil) October 11, 2022, 6:24am 4

@Ishan_Shelke

Please find the below link

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

Most Active Users - Yesterday
Anil_G
ashokkarale
jinal.shah
Gautham_Pattabiraman
postwick
chandreshsinh.jadeja
vrdabberu
Ajay_Mishra
sven.wullum1
Vyshnavi_Nalumachu
More details...

How to paste data according to column names in other sheet

Related Topics