1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Flip the rows and columns

Discussion in 'Business Applications' started by PODNickerz, Apr 8, 2007.

Thread Status:
Not open for further replies.
Advertisement
  1. PODNickerz

    PODNickerz Thread Starter

    Joined:
    Apr 13, 2002
    Messages:
    562
    Hello,

    I do not know much about excel so i need your help.
    Attached is a screenshot. Please examine it a bit to know which rows and columns the data responds to.

    Now that you done that heres the question:

    How can i switch the dates to the top row and the exercises to where the dates are but keeping the readouts of the weight measurements to its corresponding labels?
    I looked over it and it seemed like i had to do it manually but i am wondering if there was a way to automatically do it? Without all the hard work :(
     

    Attached Files:

  2. MRdNk

    MRdNk

    Joined:
    Apr 7, 2007
    Messages:
    439
    Check out the function =Transpose()

    Type into the top cell you want to put the new table (I'll use A32), and using your screenshot values:
    In cell A32: "=Transpose(A1:K27)" (don't use ") after you type that in, select starting at that cell the same area for your new table - all the cells.

    So select A32 and select to AA42, then press F2, hold down Ctrl & Shift, and then Enter, and it will Transpose the vertical to the horizontal and all the corresponding data.

    Transpose is brilliant.

    I recommend that you then copy the information from that and use paste special and keep values, then delete the complete rows with the transposed array, its annoying cos you can't change the info, so just turn it back into cell data is the best option.

    Unless you want to put it on another sheet, and want it to update from your original data.
     
  3. PODNickerz

    PODNickerz Thread Starter

    Joined:
    Apr 13, 2002
    Messages:
    562
    Oh excellent it works!!!

    Thankyou very much! :)
     
  4. MRdNk

    MRdNk

    Joined:
    Apr 7, 2007
    Messages:
    439
    No problem, glad to have helped.

    At the learning stages myself.
     
As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/559456

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice