If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|