View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
helena[_2_] helena[_2_] is offline
external usenet poster
 
Posts: 2
Default Several columns into one

Hello all,

Is it possible to concatener by formula several columns into one ?
Example: initial data
A1: A3 = {1, 2, 3}
B1: B3 = {4, 5, 6}
C1: C3 = {7, 8, 9}
Result desired, D1: D9 = {1, 2, 3, 4, 5, 6, 7, 8, 9}

Thank you in advance for your suggestions,

Helena