How to convert rows into column?

Help Studio
, ,
1

I have data in excel, it is in one row. I need to convert into column. and also I need to remove column1, column 2, column3, etc…
Can any one help me.
Thank you.
Test.xlsx (8.3 KB)

2

@Vanitha_VS

You can use Read Range activity and In range you can keep as “A2”

Enable the Headers property in Read Range

Hope this may help you

Thanks,
Srini

3

@Vanitha_VS

For removing the columns which you specified, for that you can use Filter Datatable after Read Range activity

In Filter Datatable do as below

image

Hope this may help you

Thanks,
Srini

4

Hello @Vanitha_VS

Please kindly look at this workflow i provided for you
Main.xaml (14.6 KB)
and result excel file :
Test.xlsx (9.6 KB)

This workflow will read range then Build 1 datatable with one column header name : Result
then we use for each DT.Columns and assign to set value for each row to be same with current column
after all done we filtered row by delete all value that start with “Column”
then we write datatable to Test.xlsx Sheetname : Result

Hope this workflow can help you
Best Regard,

5

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.