How to read row in one excel and write column in another excel

Learn Academy Feedback
1

Hi there,

I am trying to copy row from “excel1” to “Excel2” with column.

%E5%BE%AE%E4%BF%A1%E6%88%AA%E5%9B%BE_20180605170943

%E5%BE%AE%E4%BF%A1%E6%88%AA%E5%9B%BE_20180605171045
%E5%BE%AE%E4%BF%A1%E6%88%AA%E5%9B%BE_20180605171045774×190 4.17 KB

but t don’t know how to do, i need you help
thans.

2

Hi @jall.she,

Check this source . you can get the result.

File : ColumnName.zip (12.9 KB)

image

Regards
Balamurugan.S

1 Like
3

Hi @jall.she
I am attaching a workflow that will perform the required action for any excel with any number of rows and columns. Please let me know if you have any queries.RowsToCol.zip (14.3 KB)

Regards
Nivedita Kapil

4

thanks for your help

1 Like
5

Hi @jall.she,

You can use ‘DataTranspose’ Activity from the package ‘datamanipulations.activities’

Thnaks,
Bhushan

1 Like