View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
VickiMc VickiMc is offline
external usenet poster
 
Posts: 28
Default Transposing from two dimensional to one dimensional

Is there an array formula that will transpose from two dimensional to one
dimensional?
What I need to do is change an Excel database from multiple rows & columns
to one single column, so that I may export it into another database.
I would prefer not to use VBA if I didn't have to, and the formula would
have to allow the number of columns to be calculated either automatically or
manually, as this may vary.