+ Reply to Thread
Results 1 to 2 of 2

Moving column entries to row entries (and vice versa) automatically instead of manually?

  1. #1
    Registered User
    Join Date
    02-01-2013
    Location
    San Francisco, CA, USA
    MS-Off Ver
    Excel 2010
    Posts
    1

    Moving column entries to row entries (and vice versa) automatically instead of manually?

    I'd like to move all current column entries to row entries and row entries to column entries (I currently have my quarter and monthly dates in column 1 and would like those instead to be column titles in row 1). Mistake I'd like to fix automatically if possible instead of manually moving each cell's entries. Can't imagine this is possible, and would lose all formulas, but am hoping it might be. Thank you.

  2. #2
    Forum Contributor
    Join Date
    09-13-2011
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    216

    Re: Moving column entries to row entries (and vice versa) automatically instead of manuall

    does this help?

    http://chandoo.org/wp/2013/02/01/tra...excel-formula/

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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