select a.[Customer Name],
		a.[Address],
		a.[Sales Rep],
		b.[Order Number],
		b.[Order Date]
		from (
select  [Customer Name],
		[Address],
		[Sales Rep]
	from (SELECT * 
			FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0',
				'Excel 12.0 Xml;HDR=No;Database=C:\Projects\KPI Demo\IT 2009 Tester.xls;IMEX=1',
				'SELECT * FROM [Department Details$A3:B5]')) as sourcetable
	PIVOT
	(MAX(F2)
		for F1 in ([Customer Name],[Address],[Sales Rep])
		) as PivotTable) a
cross join (
select  null as [Customer Name],
		[Order Number],
		[Order Date]
	from (SELECT * 
			FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0',
				'Excel 12.0 Xml;HDR=No;Database=C:\Projects\KPI Demo\IT 2009 Tester.xls;IMEX=1',
				'SELECT * FROM [Department Details$D3:E4]')) as sourcetable
	PIVOT
	(MAX(F2)
		for f1 in ([Order Number],[Order Date])
		) as PivotTable) b