How to paste data according to column names in other sheet

Help Robot
,
1

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

2

Hi @Ishan_Shelke ,
Have you tried using the Transpose Datatable Activity ?

Give a try on using the Activity on the Input Datatable Itself.

Also, Maybe a First try using the Modern Excel approach would be recommended to check :

image

Let us know what is the result when it is performed on different samples of data that you have.

3

Hi @Ishan_Shelke

Check out this docs and thread

Regards
Gokul

4

@Ishan_Shelke

Please find the below link

5

HI @Ishan_Shelke

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

Hope this Helps

Regards
Sudharsan

6

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