+ Reply to Thread
Results 1 to 5 of 5

How to convert horizontal list to vertical? with formulas/ cell references!

  1. #1
    Registered User
    Join Date
    07-04-2017
    Location
    Helsinki, Finland
    MS-Off Ver
    2017
    Posts
    6

    How to convert horizontal list to vertical? with formulas/ cell references!

    Hi,

    I have this horizontal list that would need to be somehow converted to vertical one. Transponse doesn´t work because I need the formulas to be included in that list. How could I drag the formula?

    Thanks for help!
    Attached Files Attached Files

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... based in Ireland
    MS-Off Ver
    µSoft Office 365. Learning Excel all over again!!
    Posts
    30,754

    Re: How to convert horizontal list to vertical? with formulas/ cell references!

    One way:

    =OFFSET($C$2,,ROWS(C$10:C10)-1,,)
    Glenn



  3. #3
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... based in Ireland
    MS-Off Ver
    µSoft Office 365. Learning Excel all over again!!
    Posts
    30,754

    Re: How to convert horizontal list to vertical? with formulas/ cell references!

    ...or (non-volatile):

    =INDEX($C$2:$AZ$2,,ROWS($C$10:C10))

  4. #4
    Registered User
    Join Date
    07-04-2017
    Location
    Helsinki, Finland
    MS-Off Ver
    2017
    Posts
    6

    Re: How to convert horizontal list to vertical? with formulas/ cell references!

    Thank you so much!

  5. #5
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... based in Ireland
    MS-Off Ver
    µSoft Office 365. Learning Excel all over again!!
    Posts
    30,754

    Re: How to convert horizontal list to vertical? with formulas/ cell references!

    You're welcome.



    If that takes care of your original question, please select "Thread Tools" from the menu link above and mark this thread as SOLVED.

    It'd also be appreciated if you were to click the Add Reputation button at the foot of any of the posts of all members who helped you reach a solution.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 7
    Last Post: 10-19-2015, 06:11 AM
  2. [SOLVED] Vertical to Horizontal References
    By beachieb in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 09-05-2012, 03:33 PM
  3. [SOLVED] Convert Vertical list to Horizontal
    By pmor1503 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-14-2012, 10:15 PM
  4. Convert Horizontal data into a 'Cummulative' (one-column) Vertical List
    By Gabino21 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-15-2012, 11:28 PM
  5. [SOLVED] Convert Horizontal Table to Vertical List
    By TXboiler in forum Excel General
    Replies: 3
    Last Post: 04-22-2011, 09:27 PM
  6. Changing Horizontal to vertical references
    By Seriously in forum Excel General
    Replies: 5
    Last Post: 07-21-2010, 01:24 PM
  7. Convert from Vertical list to Horizontal
    By ravi_m5_2000 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-14-2009, 03:52 AM

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