Excel: Copy Data by Column and Paste The Data by Row

[fizzuraimi (Mohammad Hafiz Bin Zuraimi)]

Hello all

I need some suggestions about the excel file, I need to copy the data by the column and paste the data according to row sequence. I tried using the Read Range and Write Range function in UiPath. . I set the range like in the red circle.

The yellow highlight is the data that I want to copy .

And the yellow highlight is the result after I paste the data. But I need to paste the data by the row.

I’m new to this. Please help me. Thank you for the cooperation.

[SaranyaKishore (Saranya R)]

Hi @fizzuraimi,

Please refer this link for non-programmatic approach,

How to copy column into row (transpose)

Update small change: This is non programmatic approach. Open excel scope, follow below hot key pattern F5 (src start range) f5( src end range) Shift + enter(will select range) ctrl+c( copy src range) Alt+f4(close excel1) Open excel2 5)f5(dest start range) Alt+Ctrl+V (opens pop up) E (select transpose) Enter 9)ctrl+s (save excel)

Thanks,
Saranya K R

[fizzuraimi (Mohammad Hafiz Bin Zuraimi)]

Thank you