Transpose data between 2 excel files

I would like to transpose my data from rows to column between 2 different excel files. Has anyone attempted this before?

@yugendra.balachandran what do you mean by “between two sheets”

Hi,

How about using Copy/Paste range activity with Transpose option as the following?

Regards,