Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Insert A Block of Data Into Another Sheet | New Users to Excel | |||
Excel 2002 : How to get the difference in a block of data ? | Excel Discussion (Misc queries) | |||
Insert New Row in a block of data | Excel Discussion (Misc queries) | |||
How does one sort a block of inter-related information in Excel? | Excel Worksheet Functions | |||
Changing the format of a block of data | Excel Discussion (Misc queries) |