I have a question regarding the use of Auto Filter feature

I have data in columns with an auto filter turned on allowing me to filter down the column. However, I wish to transpose the data so it flows across the page. I wish to still use the Autofilter feature. Any ideas how to do this.