JavaScript: Sorting the columns in a 2D array by the values in a row

Question

I have an array like this:

 [[ 'Table', 'Column A', 'Column B', 'Column C'],
  [ 'Row 1', 10, 5, 7 ],
  [ 'Row 2', 20, 15, 50 ],
  [ 'Row 3', 8, 13, 3 ]]

I would like to sort the columns, so the 'most important' column shows first, by sorting on the data in 'Row 1'. Result:

 [[ 'Table', 'Column A', 'Column C', 'Column B'],
 [ 'Row 1', 10, 7, 5 ],
 [ 'Row 2', 20, 50, 12 ],
 [ 'Row 3', 8, 3, 13 ]]

Notice how column C and B has changed position.

How can I do this in JavaScript

davidkonrad · Accepted Answer · 2013-09-27 11:07:56Z

1

Do this :

var test = [[ 'Table', 'Column A', 'Column C', 'Column B'],
         [ 'Row 1', 10, 7, 5 ],
         [ 'Row 2', 20, 50, 12 ],
         [ 'Row 3', 8, 3, 13 ]];


function arrayColReorder(array, col1, col2) {
    for (var i=0;i<array.length;i++) {
        var temp=array[i][col1];
        array[i][col1]=array[i][col2];
        array[i][col2]=temp;
    }
    return array;
}

var sorted = arrayColReorder(test, 2, 3);

console.log(sorted);

enter image description here

answered Sep 27, 2013 at 11:07

davidkonrad

85.7k17 gold badges211 silver badges273 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

JavaScript: Sorting the columns in a 2D array by the values in a row

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related