Forum Discussion
Change horizontal data to vertical (no transpose)
Hello, a beginner here! I have a table with approximately 21,00 rows and 16 columns, and I want to paste my horizontal data vertically. The problem is that Excel won't let me transpose it because...
Hi zaomoni
Power Query is the best option for such data transformations.
You can use the Transpose feature in the power query to change the orientation of your data.
Click on the POWER QUERY tab in your Excel file then click From Table/Range:
It will open the power query window.
Go to Transform Tab and click Transpose.
I hope I will help you.
Please let me know if it works for you.
Thanks
Tauqeer