Transpose excel data

Hello @suraj.l
Try this by using Modern Excel activity
Using Copy/Paste Activity :

  • Utilise Excel Modern Activities to perform data Transpose.
  • Excel Process Scope → Use Excel file → Copy/Paste Activity

  • Select the Source and Destination Sheets .
  • Next, select the “All” option and activate the Transpose option.

To Enable Modern Activity:
Activity>Filter>Modern (Select it)