How to copy column into row (transpose)

Help
,
2

Update small change: This is non programmatic approach. Open excel scope, follow below hot key pattern

  1. F5 (src start range)
  2. f5( src end range)
  3. Shift + enter(will select range)
  4. ctrl+c( copy src range)
    Alt+f4(close excel1)
    Open excel2
    5)f5(dest start range)
  5. Alt+Ctrl+V (opens pop up)
  6. E (select transpose)
  7. Enter
    9)ctrl+s (save excel)
1 Like