View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
lab-guy lab-guy is offline
external usenet poster
 
Posts: 17
Default Sort Block of Data


May grow to 100 x 100. Hoping to use a database formula or an sql query .
Any ideas ?

"lab-guy" wrote:


Hi All -

I have a large block of data, 25 x 25.
(classes going down, students going across)

At the intersection, I have a concatenate formula grabbing the class &
student.

I'd like to take the contents of that block and transform to a
1 column by 625 row list. Any ideas ?

Thanks

Mike