RM - Update Resilience Survey Results Presentation to Display Questions and Answers Separately

[Diama1]

Issue

The Resilience Survey Results on the back-end currently displays all questions and their answers combined into a single field. This presentation makes it difficult to quickly interpret the results or analyze individual responses.
To improve usability and clarity, we need to separate each question into its own standalone field, with the corresponding answer displayed in its respective column.
Current Example:
All questions and answers are listed in one field, such as:
Question 1 - 2, Question 2 - 3, Question 3 - 1
Expected Example:
It would be better if Each question and its answer is presented in a separate field, such as:

Survey	Nurse	Health Center	Survey Type	Date Measured	Question 1	Question 2	Question 3	...
Survey - Annick	Annick	Bumbogo	Quarterly	2025-01-14	2	3	1	...

Tasks

• Update Result Presentation

[anvmn]

@Diama1

I suggest using code to pull existing data, process it and present in required form.
We have something similar for Devices with suspected synchronization issue:

See hedley_admin_devices_sync_state_table().