Q-1, Q-2, and Q-3 all need to be members of the same dimension. So instead of the way the data is currently formatted, I'm guessing it needs to look something like this:
Name Q Value
aa Q-1 1
aa Q-2 2
aa Q-3 4
bb Q-1 2
bb Q-2 3
bb Q-3 1
Once you've done that, you could put the "Q" dimension on your Columns shelf, Value on the Color shelf, and SUM(Number of Records) on the Rows shelf.
See these two KB articles on preparing and reshaping your data:
Thanks a lot!
the Tableau add-on for Excel does the trick.
Survey question B2.twbx.zip 38.9 KB