if you have few data to list you can use
SELECT
Product
,SUM(CASE WHEN [Date]='1-jan-2012' THEN Qty ELSE 0 END) 1jan2012
,SUM(CASE WHEN [Date]='2-jan-2012' THEN Qty ELSE 0 END) 2jan2012
,SUM(CASE WHEN [Date]='3-jan-2012' THEN Qty ELSE 0 END) 3jan2012
,SUM(CASE WHEN [Date]='4-jan-2012' THEN Qty ELSE 0 END) 4jan2012
,SUM(CASE WHEN [Date]='5-jan-2012' THEN Qty ELSE 0 END) 5jan2012
FROM
Orders
GROUP BY
Product
may be also pivot table could help
Using PIVOT and UNPIVOT