We have a school database..
We have nearly 100's of coulumns that are listed not in a format as shown in image.
Please see our current format and the output we need from the image..
Xls also attached..
http://seaplane.in/Excel-Multiple-Column-Sorting.xls
Output that is Needed
We need to list all names in a single column.
I Need to add only the values..
needs to remove the ones that does not contain the values
Is it possible to do have a function to does this automatically
How to sort multiple columns at the same time ?
If its possible how to do this ?
What we does now
We select individual column..
sort it and then copy one at a time to a OUTPUT column..
Repeat this for 100's of column
So its taking a long time
Can anyone help ?
We have nearly 100's of coulumns that are listed not in a format as shown in image.

Please see our current format and the output we need from the image..
Xls also attached..
http://seaplane.in/Excel-Multiple-Column-Sorting.xls
Output that is Needed
We need to list all names in a single column.
I Need to add only the values..
needs to remove the ones that does not contain the values
Is it possible to do have a function to does this automatically
How to sort multiple columns at the same time ?
If its possible how to do this ?
What we does now
We select individual column..
sort it and then copy one at a time to a OUTPUT column..
Repeat this for 100's of column
So its taking a long time
Can anyone help ?