New Column from Mapped Values -- Survey Monkey

Hello,

We are working with survey data using the Survey Monkey connector. From the seven questions in the survey, we are interested in looking at the "Additional Comments" question by "Location". Unfortunately, the "Location" information is obtained through a question. This means that our data looks like this:

We would like to create a card with a table where the comments can be filtered by location. (See below)

So far we have not been successful at creating this table using the regular card building tools. Our quick solution was to create a mapping Respondent_ID/Location table using Domo cards, exporting the table into an excel file, uploading it as a data source, and combining this table with the original survey results using data fusion, which yields a table like this:

While this works, the process is extremely manual and we are looking for something more streamlined. Is there an easier/more automatic way of doing this? Would it be possible to create a data flow for the ID/Mapping table and link it so that it updates the data fused table every time the survey is updated?

Thanks for any insights.

Juan