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

[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