Oracle 18c

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

CREATE TABLE YOUR_TABLE (ORGANIZATION, CLIENT_LAST_NAME, CLIENT_FIRST_NAME, SCHED_TIME, FIELD_NAME, RESPONSES, DLSEQUENCE) AS
SELECT 'DEF', 'LASTNAME', 'FIRSTNAME', TO_DATE('3/20/2020 21:20', 'MM/DD/YYYY HH24:MI'), 'Restraint?', 'No', 1349900949 FROM DUAL UNION ALL 
SELECT 'DEF', 'LASTNAME', 'FIRSTNAME', TO_DATE('3/20/2020 21:20', 'MM/DD/YYYY HH24:MI'), 'Findings',   'Findings,Findings,Findings,Findings,', 1349900949 FROM DUAL UNION ALL 
SELECT 'DEF', 'LASTNAME', 'FIRSTNAME', TO_DATE('3/20/2020 21:20', 'MM/DD/YYYY HH24:MI'), 'History',    'History,History,History,History,',     1349900949 FROM DUAL UNION ALL 
SELECT 'DEF', 'LASTNAME', 'FIRSTNAME', TO_DATE('3/20/2020 21:20', 'MM/DD/YYYY HH24:MI'), 'Treatment',  'Treament,Treament,Treament,Treament,', 1349900949 FROM DUAL UNION ALL 

SELECT 'DEF', 'LASTNAME', 'FIRSTNAME', TO_DATE('3/23/2020 21:33', 'MM/DD/YYYY HH24:MI'), 'Restraint?', 'Yes', 1350152597 FROM DUAL UNION ALL 
SELECT 'DEF', 'LASTNAME', 'FIRSTNAME', TO_DATE('3/23/2020 21:33', 'MM/DD/YYYY HH24:MI'), 'Treatment',  'Treament,Treament,Treament,Treament,', 1350152597 FROM DUAL UNION ALL 
SELECT 'DEF', 'LASTNAME', 'FIRSTNAME', TO_DATE('3/23/2020 21:33', 'MM/DD/YYYY HH24:MI'), 'Findings',   'Findings,Findings,Findings,Findings,', 1350152597 FROM DUAL UNION ALL 

SELECT 'DEF', 'LASTNAME', 'FIRSTNAME', TO_DATE('3/23/2020 21:33', 'MM/DD/YYYY HH24:MI'), 'Restraint?', 'No', 1350156095 FROM DUAL UNION ALL 
SELECT 'DEF', 'LASTNAME', 'FIRSTNAME', TO_DATE('3/23/2020 21:33', 'MM/DD/YYYY HH24:MI'), 'History',    'History,History,History,History,',     1350156095 FROM DUAL UNION ALL 
SELECT 'DEF', 'LASTNAME', 'FIRSTNAME', TO_DATE('3/23/2020 21:33', 'MM/DD/YYYY HH24:MI'), 'Findings',   'Findings,Findings,Findings,Findings,', 1350156095 FROM DUAL UNION ALL 
SELECT 'DEF', 'LASTNAME', 'FIRSTNAME', TO_DATE('3/23/2020 21:33', 'MM/DD/YYYY HH24:MI'), 'Treatment',  'Treament,Treament,Treament,Treament,', 1350156095 FROM DUAL
11 rows affected

SELECT *
  FROM YOUR_TABLE


ORGANIZATION
CLIENT_LAST_NAME
CLIENT_FIRST_NAME
SCHED_TIME
FIELD_NAME
RESPONSES
DLSEQUENCE


DEF
LASTNAME
FIRSTNAME
20-MAR-20
Restraint?
No
1349900949

DEF
LASTNAME
FIRSTNAME
20-MAR-20
Findings
Findings,Findings,Findings,Findings,
1349900949

DEF
LASTNAME
FIRSTNAME
20-MAR-20
History
History,History,History,History,
1349900949

DEF
LASTNAME
FIRSTNAME
20-MAR-20
Treatment
Treament,Treament,Treament,Treament,
1349900949

DEF
LASTNAME
FIRSTNAME
23-MAR-20
Restraint?
Yes
1350152597

DEF
LASTNAME
FIRSTNAME
23-MAR-20
Treatment
Treament,Treament,Treament,Treament,
1350152597

DEF
LASTNAME
FIRSTNAME
23-MAR-20
Findings
Findings,Findings,Findings,Findings,
1350152597

DEF
LASTNAME
FIRSTNAME
23-MAR-20
Restraint?
No
1350156095

DEF
LASTNAME
FIRSTNAME
23-MAR-20
History
History,History,History,History,
1350156095

DEF
LASTNAME
FIRSTNAME
23-MAR-20
Findings
Findings,Findings,Findings,Findings,
1350156095

DEF
LASTNAME
FIRSTNAME
23-MAR-20
Treatment
Treament,Treament,Treament,Treament,
1350156095


SELECT DLSEQUENCE,
       ORGANIZATION,
       CLIENT_LAST_NAME,
       CLIENT_FIRST_NAME,
       SCHED_TIME,
       LISTAGG("Restraint?", ',') WITHIN GROUP (ORDER BY DLSEQUENCE) AS "Restraint?",
       LISTAGG("Findings", ',') WITHIN GROUP (ORDER BY DLSEQUENCE) AS "Findings",
       LISTAGG("History", ',') WITHIN GROUP (ORDER BY DLSEQUENCE) AS "History",
       LISTAGG("Treatment", ',') WITHIN GROUP (ORDER BY DLSEQUENCE) AS "Treatment"
  FROM (SELECT DLSEQUENCE,
               ORGANIZATION,
               CLIENT_LAST_NAME,
               CLIENT_FIRST_NAME,
               SCHED_TIME,
               CASE
                 WHEN FIELD_NAME = 'Restraint?' THEN RESPONSES
                 ELSE NULL
               END AS "Restraint?",
               CASE
                 WHEN FIELD_NAME = 'Findings' THEN RESPONSES
                 ELSE NULL
               END AS "Findings",
               CASE
                 WHEN FIELD_NAME = 'History' THEN RESPONSES
                 ELSE NULL
               END AS "History",
               CASE
                 WHEN FIELD_NAME = 'Treatment' THEN RESPONSES
                 ELSE NULL
               END AS "Treatment"
          FROM YOUR_TABLE)
  GROUP BY DLSEQUENCE,
           ORGANIZATION,
           CLIENT_LAST_NAME,
           CLIENT_FIRST_NAME,
           SCHED_TIME


DLSEQUENCE
ORGANIZATION
CLIENT_LAST_NAME
CLIENT_FIRST_NAME
SCHED_TIME
Restraint?
Findings
History
Treatment


1349900949
DEF
LASTNAME
FIRSTNAME
20-MAR-20
No
Findings,Findings,Findings,Findings,
History,History,History,History,
Treament,Treament,Treament,Treament,

1350152597
DEF
LASTNAME
FIRSTNAME
23-MAR-20
Yes
Findings,Findings,Findings,Findings,
null
Treament,Treament,Treament,Treament,

1350156095
DEF
LASTNAME
FIRSTNAME
23-MAR-20
No
Findings,Findings,Findings,Findings,
History,History,History,History,
Treament,Treament,Treament,Treament,

ORGANIZATION	CLIENT_LAST_NAME	CLIENT_FIRST_NAME	SCHED_TIME	FIELD_NAME	RESPONSES	DLSEQUENCE
DEF	LASTNAME	FIRSTNAME	20-MAR-20	Restraint?	No	1349900949
DEF	LASTNAME	FIRSTNAME	20-MAR-20	Findings	Findings,Findings,Findings,Findings,	1349900949
DEF	LASTNAME	FIRSTNAME	20-MAR-20	History	History,History,History,History,	1349900949
DEF	LASTNAME	FIRSTNAME	20-MAR-20	Treatment	Treament,Treament,Treament,Treament,	1349900949
DEF	LASTNAME	FIRSTNAME	23-MAR-20	Restraint?	Yes	1350152597
DEF	LASTNAME	FIRSTNAME	23-MAR-20	Treatment	Treament,Treament,Treament,Treament,	1350152597
DEF	LASTNAME	FIRSTNAME	23-MAR-20	Findings	Findings,Findings,Findings,Findings,	1350152597
DEF	LASTNAME	FIRSTNAME	23-MAR-20	Restraint?	No	1350156095
DEF	LASTNAME	FIRSTNAME	23-MAR-20	History	History,History,History,History,	1350156095
DEF	LASTNAME	FIRSTNAME	23-MAR-20	Findings	Findings,Findings,Findings,Findings,	1350156095
DEF	LASTNAME	FIRSTNAME	23-MAR-20	Treatment	Treament,Treament,Treament,Treament,	1350156095