Thread: merge columns
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
karpagam karpagam is offline
external usenet poster
 
Posts: 1
Default merge columns

i have two columns A & B filled with 10 rows of data. I want to create
column C which should take values from columns A & B one below the other.

i.e C1 should contain A1, C2 should contain B1, C3 should contain A2, C4
should contain B2,....C19 should contain A10 and C20 should contain B10.

Pl. help to form this column C easily. My work is stuck up because of this.
I 've the same type of work to be done for several sets of columns.

Pl. help