
Choose a new location in the worksheet where you want to paste the transposed table, or if you often have to convert an Excel spreadsheet into some more usable programmatic form, why not use some of that cool knowledge you gained recently to add a chart as well to display that data more visually?