Vacation Approvals Multiple requests into one request?
For 2017 you can use STRING_AGG. 

DBFIDDLE

create table  #myTable 
([Name] varchar(64), 
 DateOfRequest date, 
 ReqLine int, 
 FromDate date, 
 EndDate date, 
 SchedCode char(2))

insert into #myTable
values
('BSMITH','20190911',1,'20190912','20190912','V8'),
('BSMITH','20190911',2,'20190914','20190915','V8')

select 
  [Name],
  string_agg(DateOfRequest,char(13)) as DateOfRequest,
  string_agg(ReqLine,char(13)) as ReqLine,
  string_agg(FromDate,char(13)) as FromDate,
  string_agg(EndDate,char(13)) as EndDate,
  string_agg(SchedCode,char(13)) as SchedCode
from #myTable
group by [Name]


This won't make your DateOfRequest unique, but if you know it will be the same for each Name then you can just select it, and add it to the group by

select 
    [Name],
    DateOfRequest,
    string_agg(ReqLine,char(13)) as ReqLine,
    string_agg(FromDate,char(13)) as FromDate,
    string_agg(EndDate,char(13)) as EndDate,
    string_agg(SchedCode,char(13)) as SchedCode
  from #myTable
  group by [Name], DateOfRequest