รบกวนขอวิธี select ข้อมูล ตามภาพหน่อยครับ ลองทำแล้วต้อง group by สาขา ไว้แถบบน group by สินค้าแถบซ้าย ที่นี้ติดปัญหาว่าไม่สามารถใส่จำนวนลงตามช่องได้เลยครับ

<?php
require_once 'PHPExcel/Classes/PHPExcel.php';
require_once 'typedate.php';

session_start();
/** PHPExcel */

error_reporting(E_ALL);

date_default_timezone_set('Asia/Bangkok');

// Write data from MySQL result
$conn = new mysqli('localhost', 'root', 'datapower', 'db_datapower');
// Check connection
if ($conn->connect_error) {
    die("ไม่สามารถเชื่อมต่อฐานข้อมูลได้ " . $conn->connect_error);
    exit;
}
// echo "ผ่าน";

mysqli_set_charset($conn, 'utf8');

$fontTahoma = array(
    'font'  => array(
        'bold'  => true,
        'name'  => 'Tahoma'
));


$objPHPExcel = new PHPExcel();
$objPHPExcel->setActiveSheetIndex(0);

//$objPHPExcel->getActiveSheet()->getPageSetup()->setOrientation(PHPExcel_Worksheet_PageSetup::ORIENTATION_PORTRAIT);
$objPHPExcel->getActiveSheet()->getPageSetup()->setPaperSize(PHPExcel_Worksheet_PageSetup::PAPERSIZE_A4);
$objPHPExcel->getActiveSheet()->getPageSetup()->setScale(100);

//$objPHPExcel->getActiveSheet()->getPageMargins()->setHerder(); // กำหนดระยะขอบ บน
$objPHPExcel->getActiveSheet()->getPageMargins()->setTop(0); // กำหนดระยะขอบ บน
$objPHPExcel->getActiveSheet()->getPageMargins()->setRight(0); // กำหนดระยะขอบ ขวา
$objPHPExcel->getActiveSheet()->getPageMargins()->setLeft(0); // กำหนดระยะขอบ ซ้าย
$objPHPExcel->getActiveSheet()->getPageMargins()->setBottom(0); // กำหนดระยะขอบ ล่าง
//$objPHPExcel->getActiveSheet()->getPageMargins()->setFooter(0.5); // กำหนดระยะขอบ ล่าง

// Set properties
$objPHPExcel->getProperties()->setCreator("Maarten Balliauw")
    ->setLastModifiedBy("Maarten Balliauw")
    ->setTitle("Office 2007 XLSX Test Document")
    ->setSubject("Office 2007 XLSX Test Document")
    ->setDescription("Test document for Office 2007 XLSX, generated using PHP classes.")
    ->setKeywords("office 2007 openxml php")
    ->setCategory("Test result file");

$sql_1 = "select arship.id,arship.code,codeship,textarship from recipes inner join arship on recipes.codeship = arship.id where so='".$_POST['so']."' group by codeship order by arship.code asc"; //group by สาขา
$query_1 = mysqli_query($conn, $sql_1);
    
$sql_2 = "select barcode,po,codepro,detail2 from recipes inner join stmas on recipes.codepro = stmas.code where so='".$_POST['so']."' group by codepro order by codepro asc"; //group by สินค้า
$query_2 = mysqli_query($conn, $sql_2);

$row = 4;
$i = 'D';

while($result_2 = mysqli_fetch_assoc($query_2)){
    $codepro = $result_2['codepro'];
    $objPHPExcel->getActiveSheet()->setCellValue('C1' , "เลขที่ใบสั่งซื้อ");
    $objPHPExcel->getActiveSheet()->setCellValue('A'.$row , $result_2['barcode']);
    $objPHPExcel->getActiveSheet()->setCellValue('C'.$row , $result_2['detail2']);
    $objPHPExcel->getActiveSheet()->setCellValue($i.'1' , $result_2['po']);
    $row++;
}
while($result_1 = mysqli_fetch_assoc($query_1)){
    $codeship = $result_1['codeship'];
    $objPHPExcel->getActiveSheet()->setCellValue($i.'2' , $result_1['code']);  
    $objPHPExcel->getActiveSheet()->setCellValue($i.'3' , $result_1['textarship']);  
    $i++;
}

$objPHPExcel->getActiveSheet()->setCellValue($i.'3' , "รวม");

$objPHPExcel->getActiveSheet()->setTitle("TEST");
// Redirect output to a client’s web browser (Excel2007)
header('Content-Type: application/vnd.openmxlformats-officedocument.spreadsheetml.sheet');
//header('Content-Type: application/vnd.ms-excel');
header('Content-Disposition: attachment;filename="homework.xls"');
header('Cache-Control: max-age=0');
// If you're serving to IE 9, then the following may be needed
// If you're serving to IE over SSL, then the following may be needed
header('Expires: Mon, 26 Jul 1997 05:00:00 GMT'); // Date in the past
header('Last-Modified: ' . gmdate('D, d M Y H:i:s') . ' GMT'); // always modified
header('Cache-Control: cache, must-revalidate'); // HTTP/1.1
header('Pragma: public'); // HTTP/1.0

$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');
$objWriter->save('php://output');
exit;