You need to Pivot your data in Tableau. For that when you bring in your data select the fields school1 , school2 and school3 and Pivot. You would get two fields . Make one of them School type and other as School. Then it's easy to create view.
pivot.twbx 13.2 KB
Blindingly simple and effective.
Thank you for pointing me in the right direction!