My survey is using a contact list that is setup with the Manager First and Last Name, Email, Direct Report 1 - 50 (DR1, DR2, DR3 etc.) that has their direct report name in different columns. When the manager authenticates into the survey with their Email I have a matrix question that shows their DR1-50 along the left (statements) and two text entry fields (scale points). When creating the dashboard I would like to create one field that is called Direct Reports instead of DR1, DR2, DR3 etc. to create a dropdown of the direct report names for filtering. In the dashboard settings, I have the DR1-50 as text sets so I thought about recoding but am not getting the results I was hoping. Thoughts?

Hi!! yes you can create a new field in data and analysis and use it to add different fields and select a separator

Am I able to combine 50 unique ID's (embedded data) into one field?

Am I able to combine 50 unique ID's (embedded data) into one field? | Experience Community