I just used Power Query to pivot and unpivot my data tables in a blink of an eye!

If I need the my data table to be in a database ready format, Power Query does it in a single click. And if I need to bring it back to a human readable format, then it's also achievable with another single click!

This has saved me hours if I wanted to manually transform the orientation of my data table. And a simply transposing won't be able to achieve this.