You can do this on MS SQL server side with following query:
declare @table table
(
Name varchar(20),
[From] Date,
[To] Date,
Rate decimal
)
insert into @table values('Amenity', '8/8/2012', '8/9/2012', 50)
insert into @table values('Amenity', '8/6/2012', '8/7/2012', 50)
insert into @table values('Amenity', '8/9/2012', '8/10/2012', 50)
insert into @table values('Amenity two', '7/28/2012', '7/31/2012', 0)
insert into @table values('Amenity two', '8/3/2012', '8/4/2012', 0)
select
case when number = 1 then Name else '' end as Name, [From], [To], Rate
from (
select
row_number() over(partition by Name order by Name desc) number,
Name, [From], [To], Rate
from @table
) [inner]