is it possible to show the columns in rows in a table card??
Using the ETL tool and using the Uncollapse Columns block may be of use. (See attached)
I agree with @guitarhero23
Until we get access to those pivot tables that were unveiled at DP, I don't think you can do this without putting the data set through a Dataflow (ETL or MySQL).
Let us know if you would like help with the configuration.