2 of the methods shown to transpose data in Excel are dynamic. Number 3 will surprise you. It will show you a simple way to switch your data from rows to columns or vice versa.
Copy and paste this URL into your WordPress site to embed
Copy and paste this code into your site to embed