+ Reply to Thread
Results 1 to 2 of 2

Horizontal to vertical dragging of formulas...

  1. #1
    Forum Contributor
    Join Date
    03-24-2010
    Location
    North West UK
    MS-Off Ver
    2013
    Posts
    112

    Horizontal to vertical dragging of formulas...

    Hi,

    I have two spreadsheets and on say Spreadsheet 1 I have two rows (rows 1 & 2) from column A to AE.

    On Spreadsheet 2 I want a formula that will copy in column A all the data that is in Spreadsheet 1 from A1 to AE2 and then in Column B do the same for A2 to AE2. So basically converting the horizontal presentation of the data into a vertical column.

    I know how to drag formulas down but unsure on the horizontal to vertical dragging.

    Any help would be great, thanks.

    (Excel 2002)

    Lew

  2. #2
    Forum Expert XOR LX's Avatar
    Join Date
    04-18-2013
    Location
    Turin, Italy
    MS-Off Ver
    Office 365
    Posts
    7,742

    Re: Horizontal to vertical dragging of formulas...

    Hi,

    If this is a one-off operation, you can simpy use Paste Special/Transpose.

    If it's something that requires longer-term automation, then, in your first cell in column A of Spreadsheet 2 and copied down and to the right:

    =INDEX('[Spreadsheet 1.xlsx]Sheet1'!$A$1:$AE$2,COLUMNS($A:A),ROWS($1:1))

    Obviously amend the workbook and sheet names accordingly.

    Regards
    Click * below if this answer helped

    Advanced Excel Techniques: http://excelxor.com/

+ 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: 5
    Last Post: 08-21-2012, 03:36 PM
  2. Horizontal dates put in vertical formulas
    By bajo671 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-29-2012, 03:17 PM
  3. Copying formulas from horizontal to vertical
    By pmd in forum Excel General
    Replies: 6
    Last Post: 09-06-2011, 11:38 AM
  4. Horizontal to vertical
    By aaslezak in forum Excel General
    Replies: 4
    Last Post: 03-30-2009, 11:47 AM
  5. horizontal to vertical
    By mlecho in forum Excel General
    Replies: 1
    Last Post: 08-29-2007, 04:12 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