SQL Server 2016

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

DECLARE @T AS TABLE
(
    ID          INT,
    Mortality VARCHAR(10),
    Readmission varchar(10),
    EDVisit varchar(10),
    Return_to_OR varchar(10),
    Sepsis varchar(10)
);

insert into @T VALUES
(1,'Y', 'N', 'Y','Y','Y'), 
(2,'N','Y','N','Y','Y'), 
(3,'N','N','N','Y','Y')

select A.*
      ,B.*
 From @T A
 Cross Apply (
                Select Indicator1 = max(case when Seq=1 then [Key] end)
                      ,Indicator2 = max(case when Seq=2 then [Key] end)
                      ,Indicator3 = max(case when Seq=3 then [Key] end)
                      ,Indicator4 = max(case when Seq=4 then [Key] end)
                      ,Indicator5 = max(case when Seq=5 then [Key] end)
                From (
                      Select [Key]
                            ,Value
                            ,Seq = row_number() over (order by (select null))
                        From OpenJson((Select A.* For JSON Path,Without_Array_Wrapper )) 
                        Where [Key] not in ('ID')
                          and Value<>'N'
                     ) B1
             ) B

ID	Mortality	Readmission	EDVisit	Return_to_OR	Sepsis	Indicator1	Indicator2	Indicator3	Indicator4	Indicator5
1	Y	N	Y	Y	Y	Mortality	EDVisit	Return_to_OR	Sepsis	null
2	N	Y	N	Y	Y	Readmission	Return_to_OR	Sepsis	null	null
3	N	N	N	Y	Y	Return_to_OR	Sepsis	null	null	null

Warning: Null value is eliminated by an aggregate or other SET operation.