Rows to Columns in ADF

is there a way to transpose rows to columns in Azure Data Factory e.g. I have an excel file with some vertical data in 2 column c1 & c2

c1 c2

A   B 
1   2
C   D


A  1  C
B  2  D

where A - 1 - C are the new columns and one row with the values B - 2 - D .

Thanks .


  • Pivot transformation:

    Unpivot transformation: