Problems Formatting My Table...

I have a table that looks like this...


City State Server Type
Chicago IL Svr1 Data
Chicago IL Svr2 Data
Chicago IL Svr3 Backup
Chicago IL Svr4 Backup
Atlanta GA Svr1 Data
Atlanta GA Svr2 Data



I already have a function to convert the server rows into a comma delimited string...
ALTER function dbo.fnGetServers (@City varchar(25), @State varchar(25), @Type varchar(25), @Tree varchar(25))
returns varchar(1000)
as
begin
declare @NewSvrCol varchar(1000)
select @NewSvrCol = ''
select @NewSvrCol = @NewSvrCol + Server + ', ' from serverops.dbo.v_userviews where city = @City and State = @State and Type = @Type and Tree = @Tree
select @NewSvrCol = left(@NewSvrCol, len(@NewSvrCol)-1)
return(@NewSvrCol)
end

Any suggestions on how to display the table in the following format?


City State DataSvrs BackupSvrs
Chicago IL Svr1,Svr2 Svr3,Svr4
Atlanta GA Svr1,Svr2 NULL