3v4l.org

run code in 300+ PHP versions simultaneously
<?php $data = array ( 0 => array ( 0 => 'ABC', 1 => 'XYZ' ), 1 => array ( 1 => 'ADW', 20 => 'XYZ', 26 => 'AA2', 30 => 'PQR', 60 => 'WWW', 701 => 'ZZZ' ) ); $result = array(); foreach ($data as $rownum => $row) { foreach ($row as $colnum => $value) { if ($colnum >= 26) { $col0 = $colnum % 26; $col1 = intdiv($colnum, 26); $colstr = chr(64 + $col1) . chr(65 + $col0); } else { $colstr = chr(65+$colnum); } $result[$colstr . ($rownum+1)] = $value; } } print_r($result);
Output for 7.4.0 - 7.4.33, 8.0.1 - 8.0.30, 8.1.0 - 8.1.33, 8.2.0 - 8.2.29, 8.3.0 - 8.3.26, 8.4.1 - 8.4.13
Array ( [A1] => ABC [B1] => XYZ [B2] => ADW [U2] => XYZ [AA2] => AA2 [AE2] => PQR [BI2] => WWW [ZZ2] => ZZZ )

preferences:
97.39 ms | 407 KiB | 5 Q