Hi,
Is there any shortcut method to cut mutiple rows in to paste single column (But I am using cut single row and paste special - Transpose)
AB AC AD AE AF
BB BC BD BE BF
** CE CF CR CF
AB
AC
AD
AE
AF
BB
BC
BD
BE
BF
**
CE
CF
CR
CF
Hi,
Is there any shortcut method to cut mutiple rows in to paste single column (But I am using cut single row and paste special - Transpose)
AB AC AD AE AF
BB BC BD BE BF
** CE CF CR CF
AB
AC
AD
AE
AF
BB
BC
BD
BE
BF
**
CE
CF
CR
CF
What if it's blank instead of BE?
is it in column also blank or skipped?
BD
BF
Blank or Skipped - it is doesn't matter.... I need it single column.
Thanks for your effort...
tyr this code
Please Login or Register to view this content.
Please explain me step by step to execute the code
From your workbook press Alt+F11
(now you will be in Visul Basic editor)
from menu bar Insert>Module
copy the code given in the last post and paste in the Module, then close the active window(VB editor)
Press Alt+F8 (you will find list of Macros)
select 'Start' macro then click Run
this is the Non-VBA technique that I use
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks