What type of data source are you using.
Tableau will do a PIVOT on two (or more) columns of your data, and create virtual rows for you. It works for excel, MS SQL and some other data source types.
I believe this is based on Oracle. I don't see the option to pivot - unsure if it's because of my permissions or the type of database. That would definitely be an easy solution - I'll look into it with our DB administrator.