Share via

How do I transpose rows to columns?

Anonymous
2020-11-16T15:06:34+00:00

Split from this thread about a different Excel feature.

I'm trying to format a table from Yahoo Finance when I run a Web Query.

The data come in as columns, but I need to convert into rows for my Excel spreadsheet.

How can I do this?

Also, not all the data that I want from my web query is there, so is there a way for me to select the data that I want from the web page?

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Jim G 134K Reputation points MVP Volunteer Moderator
2020-11-16T16:04:25+00:00

Hi

Excel has a built-in Transpose feature that you can use to transpose data from rows to columns. These links are from the Help menu in Excel when you search for Transpose.

TRANSPOSE function

The TRANSPOSE function syntax has the following argument: array Required. An array or range of cells on a worksheet that you want to transpose. The transpose of an array is created by using the first row of the array as the first column of the new array, the second row of the array as the second column of the new array, and so on.

Transpose data from rows to columns (or vice versa) in Excel for Mac

Tips for transposing your data. If your data includes formulas, Excel automatically updates them to match the new placement. Verify these formulas use absolute references—if they don’t, you can

Let's stick with answering one question per thread. Please start a new thread with your questions about how to make a query that gives you the columns you wish to have. It would be helpful to tell us the query you are currently using as a starting point.

Was this answer helpful?

0 comments

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2020-11-18T20:40:22+00:00

    Hi BrianDonnahoo,

    Feel free to post back if you need further assistance. 

    Best Regards,

    Waqas Muhammad

    Was this answer helpful?

    0 comments
  2. Anonymous
    2020-11-16T16:11:04+00:00

    Hi BrianDonnahoo,

    I apologize for all the trouble it has caused and sorry about your time.

    As per your description, for transpose rows to columns data in excel for mac here is article you may refer: Transpose data from rows to columns (or vice versa) in Excel for Mac

    Regarding to “sois there a way for me to select the data that I want from the web page?” Maybe Macro can meet the requirement, here is an article for your reference:

    Making and Using Excel web queries

    Disclaimer: Microsoft provides no assurances and/or warranties, implied or otherwise, and is not responsible for the information you receive from the third-party linked sites or any support related to technology.

    A web query gets content that is in HTML tables. Another way to get a table into a workbook is to view the HTML source code. Select all content including beginning and ending TABLE tags, then paste the HTML code into a single Excel cell.

    <TABLE>

    ..[content]...

    <\TABLE>

    Besides, I would also like to welcome community members who has experience in this area to share some ideas with us.

    I appreciate your patience and understanding.

    Best Regards

    Waqas Muhammad

    Was this answer helpful?

    0 comments