+ Reply to Thread
Results 1 to 3 of 3

transpose from A1 to A2

  1. #1
    Forum Contributor
    Join Date
    08-10-2010
    Location
    Tavira, POrtugal
    MS-Off Ver
    Excel 2010
    Posts
    132

    transpose from A1 to A2

    Good Morning
    I need help because I am trying to transpose the following values, just like the attached file.
    I've tried with matrix formula, but I can not get what I want.
    Attached Files Attached Files
    Last edited by Birnen; 01-19-2017 at 12:29 PM.

  2. #2
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,064

    Re: transpose from A1 to A2

    in J4
    =INDEX($B$4:$F$9,(ROW()-4)*2+1,COLUMN()-9)
    copy across and down to N6

    in P4
    =INDEX($B$4:$F$9,(ROW()-4)*2+2,COLUMN()-15)
    copy across and down to T11
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

  3. #3
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2021
    Posts
    8,914

    Re: transpose from A1 to A2

    j4
    Please Login or Register  to view this content.
    and copy across
    p4
    Please Login or Register  to view this content.
    and copy across
    Samba

    Say thanks to those who have helped you by clicking Add Reputation star.

+ 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. [SOLVED] Use the TRANSPOSE() function to transpose a range as an input to the UDF
    By alice2011 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 03-09-2015, 09:35 PM
  2. transpose column to a range calculate and transpose to new table loop
    By moshro1 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-02-2015, 10:52 AM
  3. [SOLVED] Excel 2007 : Cut\transpose vs. copy\transpose
    By sarahaley in forum Excel General
    Replies: 3
    Last Post: 05-09-2012, 05:45 PM
  4. [SOLVED] Transpose: How can I copy a list and transpose it but leaving 3 cells in between each item
    By cocolete in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 04-11-2012, 10:01 AM
  5. Replies: 2
    Last Post: 02-19-2007, 04:53 PM
  6. Replies: 1
    Last Post: 12-29-2005, 07:50 PM
  7. [SOLVED] I WANT TO TRANSPOSE LINKS, AS WE TRANSPOSE VALUES
    By Umair Aslam in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-22-2005, 09:05 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