Sort entries in a column based on sort order of other column?

deckoff

Probably this question might sound weird at least?
Consider table with lets say five rows.
Column 1 has text entries and Column 2 has number entries (this is by design). Every entry in column A correspond to value in C2. Column 2 is hidden(fetched, but not shown). I want when the user clicks on column 1 to sort entries, the entries to be sorted based on values in Column 2

Fol example:

2WW 4
1B 2
R 1

Should be sorted (smallest to largest)

R
1B
2WW

Hope I make myself clear enough

dwbiz05

This might point you in the right direction:

http://datatables.net/ref#aDataSort

Or you may need to use something like this api:

http://datatables.net/ref#fnSortListener

I haven't messed with it myself, but a quick look through the reference table showed these options.

Hope it helps,

Dave