No. SQL Server does not have any native mechanism to do cross-tabs. You can either implement the functionality on the client or, if you have a fixed number of columns, use the CASE function.

SELECT
office.name,
SUM(CASE WHEN sales.month=1 THEN sales.amt ELSE 0 END) AS jansales,
SUM(CASE WHEN sales.month=2 THEN sales.amt ELSE 0 END) AS febsales,
...
FROM
office
INNER JOIN sales ON sales.officeid = office.officeid
GROUP BY
office.name

-Mike