Sort Block of Data
 

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

Sort Block of Data
 

If you only have to do it once, just bite the bullet and cut and paste a
column at a time..........

If you will have to do it again sometime, record a macro while you do it the
first time.....next time just run the macro.

Vaya con Dios,
Chuck, CABGx3



"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

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

Sort Block of Data
 

Personally, I would whip over to the Programming Group and see if someone
would be so kind as to do you a little macro that would step over however
many columns you have and append them to the bottom of column A......

Vaya con Dios,
Chuck, CABGx3



"lab-guy" wrote:


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