JavaScript: Arranging the columns in a two-dimensional array based on the elements in a specific row

Question

JavaScript: Arranging the columns in a two-dimensional array based on the elements in a specific row

Here is an example of an array:

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

I am looking to rearrange the columns based on values in 'Row 1' to prioritize the most important column. The desired result is:

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

Observe how column positions have changed for C and B.

Any suggestions on how to achieve this using JavaScript?

javascript arrays sorting

Answer 1

Answer №1

Follow these steps :

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


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

let modifiedArray = switchColumns(arrayData, 2, 3);

console.log(modifiedArray);

Answer 2

Follow these steps :

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


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

let modifiedArray = switchColumns(arrayData, 2, 3);

console.log(modifiedArray);

JavaScript: Arranging the columns in a two-dimensional array based on the elements in a specific row

Answer №1

Similar questions

What is the process for creating a series using a provided array?

What options are available for labels in Bootstrap v5.0.0-beta1 compared to BS 3/4?

Eliminating the Skewed Appearance of Text in Input Fields Using CSS

JavaScript on Ruby on Rails stops functioning in js.erb file

Handling click events on several elements in Angular

Cease the execution of promises as soon as one promise is resolved

Personalized Owl Carousel - OWL.JS Hover Pause Feature

The outcome of my function designed to calculate the highest possible profit using k transactions is a null array

Mobile devices seem to be constantly refreshing website images

React displaying incorrect data during array iteration

The custom tooltip is not being displayed as intended

The functionality of ngSubmit and ngDisabled seems to be malfunctioning, although ngModel is successfully linked to the

Utilizing request parameters within middleware that employs the 'createHandler' function from the 'graphql-http' package

There is a message showing up on the console log, but unfortunately, it

Photo uploading in ASP.NET MVC - encountering null HttpPostedFileBase issue

What could be causing the second switchMap to be triggered repeatedly upon subscription?

React components are failing to display data as expected

Fixed columns with horizontal scrolling to prevent Datatables columns from overlapping

Troubleshooting UV Mapping Problem in THREEJS JSON Model

In ASP.Net, looking to execute JavaScript once the update panel finishes loading