How to Transpose Multidimensional Column Data into a Row Data Array?

Transpose Multidimensional Column Data into a Row Data Array

The task involves transforming a multidimensional associative array of column data into an array of rows, effectively transposing the data structure. The given input array consists of three columns: id, date, and 'time', each containing corresponding data values. The goal is to reorganize the data such that each row represents a combination of the column values.

One approach to solving this problem is to utilize the array_column() function. This function extracts a column from a multidimensional array, enabling the creation of a new array with the transposed values. However, it requires iterating through the input array to assemble the result.

Alternatively, a more straightforward solution is presented by the foreach loop method. This approach involves using an index variable to navigate the input array and progressively build the result array. For each element in the id column, the corresponding values from the date and time columns are added to a row in the result array.

By using this method, the desired output is obtained, which is an array of rows with merged column data:

[
  [12, '1999-06-12'],
  [13, '2000-03-21'],
  [14, '2006-09-31']
]

By employing these techniques, it is possible to effectively transpose multidimensional column data into a more useful row-based data structure.

The above is the detailed content of How to Transpose Multidimensional Column Data into a Row Data Array?. For more information, please follow other related articles on the PHP Chinese website!