Uipath Data Scraping ribbon 1 row of data to multiple column

[Irfan_Musa]

Hi I am trying to use Data Scraping ribbon of 1 row of data to each data having a column, but I could not get it.

I can only get the data in 1 column.

Any ideas on how to go around this? Your help is very much appreciated.

[mkankatala (Mahesh Kankatala)]

Hi @Irfan_Musa

It was extracting the column as rows. we have to do the transpose.
For better understanding find the below video which help you to transpose the row to columns as you required.

UiPath Transpose Excel Data Vica Versa | Transpose Row to Column and Column to Row UiPath RPA

Hope it helps!!

[Irfan_Musa]

Is there a way I can edit the xml editor to do this?

[mkankatala (Mahesh Kankatala)]

May be @Irfan_Musa. But i don’t have much idea about XML editor.

[Irfan_Musa]

Hi I still can’t fix the error, it is still not showing in my csv files