View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Claus Busch Claus Busch is offline
external usenet poster
 
Posts: 3,872
Default Convert multiple columns into a single row

Hi,

Am Sat, 23 Mar 2013 17:40:41 +0000 schrieb dearpt:

This is how the excel looks

A B C D E

i have to convert this to

A
B
C
D
E


copy the values = Paste special = Transpose


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2