+ Reply to Thread
Results 1 to 3 of 3

Switching a Horizontal List to a Vertical List

  1. #1
    Forum Contributor
    Join Date
    11-11-2011
    Location
    London England
    MS-Off Ver
    Excel 2011 for Mac
    Posts
    157

    Question Switching a Horizontal List to a Vertical List

    Hi,

    I've got a slightly random question that I think that there may be an obvious answer to:

    I have a horizontal list of teams (as part of a HLOOKUP with team names on one row and a rating on another). The teams (64) are listed horizontally from A2 to BL2.

    I have set them to play out a tournament and have generated a data table to generate results.

    In short, can I list the teams in A2-BL2, vertically in G67-G130 (so I can set up a log of the data table results to generate winning percentages). With my data table set up vertically and given the number of teams it would just be easier to do this vertically for printing off, rather than doing it horizontally (e.g. you could see a significant numbers of row vertically but only 6 or so columns horizontally - if that makes sense).

    I know I could re-type everything from A2-BL2 into G67-G130 (e.g. directly copy A2 to G67) - but I just wondered if there was a more elegant (and quicker) way of doing this.

    Thanks for any advice offered.
    Last edited by mrvp; 02-28-2012 at 07:23 PM.

  2. #2
    Forum Expert DGagnon's Avatar
    Join Date
    02-23-2012
    Location
    Ontario, Canada
    MS-Off Ver
    Excel 2003, 2007
    Posts
    1,645

    Re: Switching a Horizontal List to a Vertical List

    when you copy the list, you can paste by right clicking, paste special, then click on the checkbox for Transpose
    If you liked my solution, please click on the Star -- to add to my reputation

    If your issue as been resolved, please clearly state so and mark the thread as [SOLVED] using the thread tools just above the first post.

  3. #3
    Forum Contributor
    Join Date
    11-11-2011
    Location
    London England
    MS-Off Ver
    Excel 2011 for Mac
    Posts
    157

    Re: Switching a Horizontal List to a Vertical List

    Solved. Spot on. I can't believe I didn't see this (I suppose things are easy when you know what you are looking for though). Thanks for your help - much appreciated.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1