移位数组值PHP

Question

Please Help me. I have And Following array :

    [0] => Array (
        [0] => Name
        [1] => Age
        )
    [1] => Array (
        [0] => Name 1
        [1] => 20
        )
    [2] => Array (
        [0] => Name 2
        [1] => 21
        )
    [3] => Array (
        [0] => Name 3
        [1] => 22
        )
    [4] => Array (
        [0] => Name 4
        [1] => 23
        )
    [5] => Array (
        [0] => Name 5
        [1] => 24
        )

I want to achieve shift the values of array like this output:

Because when exporting excel file into php database values will insert incorrectly with shifting of 1 row of age:

[0] => Array (
    [0] => Name
    [1] => 20
    )
[1] => Array (
    [0] => Name 1
    [1] => 21
    )
[2] => Array (
    [0] => Name 2
    [1] => 22
    )
[3] => Array (
    [0] => Name 3
    [1] => 23
    )
[4] => Array (
    [0] => Name 4
    [1] => 24
    )
[5] => Array (
    [0] => Name 5
    [1] => 25
    )

Thanks In Advance.

Answer 1

You can also loop then check for the last array key

$array = [
    ["Name","Age"], ["Name 1","20"], ["Name 2","23"], ["Name 3","30"],
    ["Name 4","20"], ["Name 5","26"], ["Name 6","27"], ["Name 7","21"], ["Name 8","26"]
    ];

// Get last array key using count() or you can use end() then key()
$last_key = count($array) - 1; 

$result = []; // initialize result array

foreach ($array as $key => $value) {
    if ($key == $last_key) break;                       // if last key, break loop
    $result[] = [ $array[$key][0], $array[++$key][1] ]; // push name, age+1 values
}

print_r($result);