Forum Discussion

zaomoni's avatar
zaomoni
Copper Contributor
Jun 21, 2023

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 the areas are not equal. How could I fix this or change the data orientation in another way?

 

English isn't my mother tongue so I apologize if there are mistakes in my wording.

 

Here's a screenshot (in Spanish)

 

excel
Formulas and Functions
  • tauqeeracma's avatar
    tauqeeracma
    Steel Contributor
    Jun 21, 2023

    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

     

Resources