I have 5 categories of review and each category has 10 questions. Each question has a score of 1-5. This forms the basis of a survey.
I would like to map the survey answers into a table. The reason is it helps us classify the supplier relationship we have. The answers also determine actions and gaps to address.
I've tried some index/match lookup functions but cannot seem to concatenate functions whereby, if two text answers need to belong in the same cell, how to show this? I have described a little further on the spreadsheet and would really appreciate some creative thinking.
Bookmarks