What do you mean by "linked together"? On SQL Server, if you join the tables using the Multiple Tables option of the data connection properties, the desired view should not be difficult at all to create:
Name from Table 1 on Columns
Name from Table 2 on Rows
Passed on Text.
Thank you for your reply. You are indeed correct. The reason we were struggling was because we had made a simple error in linking the tables together in the first place, which is why we struggling to achieve the desired outcome.
The problem arose when we tried to link an additional two tables to the 6 we already had running from the SQL server, we miscalculated and Tableau was pulling through some information but not all of it, after re-evaluating the links the issue was resolved.
You're welcome! Glad you got it!