Need inputs to display the data in a single row

Hi All,

In a custom table, I have data as shown below,

NotificationId	State	Substate	Outcome	Assignd_User	Last_update_date
1234		ASSIGNED		abc@gmail .com	21-jan-2026 11:10am
1234	ASSIGNED	ACQUIRED		xyz@gmail .com	22-jan-2026 10:15am
1234	ASSIGNED	ACQUIRED		abc123@gmail .com	22-jan-2026 3:25pm
1234	OUTCOME		APPROVE	aa123@gmail .com	23-jan-2026 08:18am
1234	ASSIGNED	ROUTED		bb123@gmail .com	24-jan-2026 10:10am
1234	ASSIGNED	ACQUIRED		cc122@gmail .com	24-jan-2026 06:21pm
1234	OUTCOME		APPROVE	dd4456@gmail .com	25-jan-2026 11:35am

Using the above data, we need to build a SQL query that displays the results in a single row for each NotificationId. Could you provide any inputs on how to achieve the following format using SQL?