I'm new to Tableau, and I'm having trouble connecting two data files. One is the data data dictionary for my project, stored as an Excel file, while the other is the data itself, stored as a CSV. A simplified example:

Data dictionary:

Data:

I'm hoping to link these two data sets so I can display the survey results alongside the associated question, and I thought that because they share common variable names, I would be able to do this. However, Tableau appears to be interpreting the data dictionary as additional rows of data, and when it tries to put a string in what is currently a measure field, it throws errors. (For example, it appears to be trying to create another respondent whose answer to variable name "Apples" is "How many apples do you eat per week?") How can I associate the question text with each variable name in the data set? Transposing the axes in the Excel file didn't seem to help.