sorting table into 2 columns

[stavpal]

Sorry for being such a complete noob, but how can I sort a table into 2 columns?

xls (in zip)attached...

To see the way I need it sorted go from sheet1 to sheet2

Thanks in advance

[FrankBoston]

I have attached your worksheet with formulas that "unroll" the data in your table, so that you can sort it. This gives you a manageable process for doing this repeatedly. Post any additional questions you might have.

[stavpal]

Thanks....how can I make the formula so it doesn't count the empty cells as "zero"?

[FrankBoston]

The "unrolling" formula generates a result value for every cell in the rectangular table. They have to have some value.

The easiest answer is to sort the zeroes away. Discard them as a group after the sort.

If zero is a valid table entry or header entry, then I might do one of the following:
- Fill in the "blank" cells with some reserved value, then sort that away.
- A user defined function (using Excel Visual Basic) could be used to capture the Formula from the source cell, rather than the Value as evaluating a formula does. This would preserve blank cells as having a blank formula.