Oracle SQL-wise its pretty easy:

select product, sum(decode(region, 'asia', quantity,0)) as "Asia", sum( decode(region, 'australia',quantity,0)) as "Australia", sum( decode(region, 'UK',quantity,0)) as "UK", sum(quantity) as "Total Imported"
from whateverthetablenameis
group by product

AKA: Pivot report.