View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
CherylH CherylH is offline
external usenet poster
 
Posts: 15
Default copy text in multiple columns into one column

I have the following:

Col #1 Col #2 Col #3
Z1 ZA ZM
Z2 ZB ZN

I want it to be in ONE column:
Col #1
Z1
Z2
ZA
ZB
ZM
ZN

Can I automatically do this vs. manually cutting and pasting?

Thanks in advance for any help!
Cheryl