Convert CSV columns to Rows

[suvarnalaxmi]

I am trying to convert the above columns to rows in CSV file. Can someone help me how to convert this?

[Lahiru.Fernando]

Hi @suvarnalaxmi

Welcome to the community!!

You can use the custom activity that enables you to do data transpose…

https://go.uipath.com/component/data-manipulations

This package includes a user guide which explains how to configure your activity to get the required output.

[ParasTripathi]

@suvarnalaxmi

To Convert Columns to rows please go through with below workflow:

Convert Columns To Rows In CSV/EXCEL

Hello Community, Use Below Code to Convert Columns to Rows/Rows to COlumns: Component - Rotate column to Rows-ParasTripathi.xaml (12.6 KB) It’s contains 4 Arguments: in_InputFilePath: Path of input file as String or in_dt as datatable in_OutputFilePath: To write the data in that location as String out_dt: Output data as DataTable Thanks & Regards, Paras

Hope it will work for you!!!
Cheers @suvarnalaxmi

[suvarnalaxmi]

@ParasTripathi
Thanks,That worked for me.

[ParasTripathi]

@suvarnalaxmi
You’re welcome, it has been my pleasure to help you out!

Cheers @suvarnalaxmi