USE tempdb

IF EXISTS(SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'#Test1'))
BEGIN
 DROP TABLE #Test1
END

CREATE TABLE #Test1(
	Name NVARCHAR(20),
	LastName NVARCHAR(40),
	Birth DATETIME
)

INSERT INTO #Test1
SELECT 'Вася', 'Петров', CONVERT(DATETIME, '2000-01-01 00:00:00.000')
UNION ALL
SELECT 'Петя', 'Иванов', CONVERT(DATETIME, '2000-02-02 00:00:00.000')
UNION ALL
SELECT 'Петя', 'Васильев', CONVERT(DATETIME, '2000-02-02 00:00:00.000')
UNION ALL
SELECT 'Коля', 'Сидоров', CONVERT(DATETIME, '2000-04-04 00:00:00.000')
UNION ALL
SELECT 'Коля', 'Гейтс', CONVERT(DATETIME, '2000-01-04 00:00:00.000');

SELECT * FROM #Test1;

with cte1 as(
SELECT '' as Name1, Name, LastName, convert(char(23), Birth, 121 ) as Birth, 
       rank() over (order by Name) as r
FROM #Test1),

cte2 as (
select distinct Name as Name1, '' as Name, '' as LastName, '' as Birth,
       rank() over (order by Name) as r
from #Test1),

cte3 as(
select *
from cte1
union all
select *
from cte2)

select Name1, LastName, Birth 
from cte3
order by r, Name