how to convert a column wise data into the Row wise data in Azure data factory?

Question

I have one Column which is having Multiple value like

Account No ---> Values

12345------{PC Accessories, Surface, Xbox, Cross Category, Windows, Microsoft 365}

I want to change the Value in the Row Wise

Account No Value

12345----PC Accessories,

12345 Surface,

12345 Xbox

12345 Cross Category

12345 Windows,

12345 Microsoft 365

Answer 1

Hey, you can use unpivot function in adf data flow.
https://learn.microsoft.com/en-us/azure/data-factory/data-flow-unpivot

In case if your datasource is a SQL source itself, would suggest leveraging unpivot sql function