Data is not displaying in 1 rows

Hi Amit

Below is the query . I want to display data in 1 row .In below code there are 12 levels , i want data in 1 rows.

I am following this link - https://www.datameer.com/blog/sql_how-to-use-pivot-to-convert-rows-to-columns-in-sql-server-db/

Hi Amit

If i comment below lines then it is working fine , but i want to add these columns also.

   --,L.[LogDetail] [Status]
   --,L.[RequestDate] [Entry Date]
   --,L.[ApprovalDate] [Completion Date]
   --,DATEDIFF(d,L.[RequestDate],L.[ApprovalDate]) as [Total Days]

PR Number	Status	Entry Date	Completion Date	Total Days	DaysToApprove	LevelName
209	PR Request Approved	2020-04-07 12:57:32.833	2020-05-07 12:44:43.307	30	30	Level 1
209	PR Request Approved	2020-05-07 12:44:43.307	2020-05-08 16:21:39.327	1	1	Level 2
209	PR Request Approved	2020-05-08 16:21:39.327	2020-05-18 17:53:29.793	10	10	Level 3
209	PR Request Approved	2020-05-18 17:53:29.793	2020-06-26 10:56:05.847	39	39	Level 4
209	PR Request Approved	2020-06-26 10:56:05.847	2020-07-07 09:05:04.503	11	11	Level 5
209	PR Request Approved	2020-07-07 09:05:04.503	2020-07-07 09:05:36.577	0	0	Level 6
209	PR Request Approved	2020-07-07 09:05:36.577	2020-07-07 12:18:20.127	0	0	Level 7
209	PR Request Approved	2020-07-07 12:18:20.127	2020-07-08 16:24:42.723	1	1	Level 8
209	PR Request Approved	2020-07-08 16:24:42.723	2020-07-08 16:26:17.620	0	0	Level 9
209	PR Request Approved	2020-07-08 16:26:17.620	2020-07-10 09:31:18.310	2	2	Level 10
209	SAP PR Number Updated	2020-07-10 09:31:18.310	2020-07-10 10:56:16.060	0	0	Level 11
209	PR Request Approved	2020-07-10 10:56:16.060	2020-07-16 12:03:01.053	6	6	Level 12

Thanks