Results 1 to 9 of 9

Transpose

This is a discussion on Transpose within the Excel Questions forums, part of the Question Forums category; I am trying to transpose a list of names in line A3:Z3 To another work sheet in the book to ...

  1. #1
    Board Regular
    Join Date
    Sep 2008
    Posts
    57

    Default Transpose

    I am trying to transpose a list of names in line A3:Z3 To another work sheet in the book to A3:A27. I keep getting the result NAME?.

    I would appreciate any help.

    Thanks

  2. #2
    MrExcel MVP
    Moderator
    Inactive
    Richard Schollar's Avatar
    Join Date
    Apr 2005
    Location
    UK
    Posts
    23,696

    Default Re: Transpose

    Are you tryingto do this using the TRANSPOSE formula? What is the formula if so?
    Richard Schollar

    Using xl2013

  3. #3
    Board Regular
    Join Date
    Jul 2002
    Location
    Milton Keynes, England
    Posts
    11,043

    Default Re: Transpose

    Well, if you showed us what formula you were using that would be a start.

    But, working in the dark here, you should be selecting cells A3:A27 in the target sheet, and typing =TRANSPOSE(Sheet1!A3:Z3) and pressing Ctrl-Shift-Enter.
    Cheers, Glenn.

    Beauty is in the eye of the beer-holder.

  4. #4
    MrExcel MVP
    Like totally RAD man
    Colin Legg's Avatar
    Join Date
    Feb 2008
    Location
    UK
    Posts
    3,477

    Default Re: Transpose

    What exactly have you tried?

    It should be A3:A28, yes?

    Select the range A3:Z3 and copy.
    Go to your target sheet and select the cell A3.
    Right click, paste special. Tick the Transpose option. OK.


    Colin

  5. #5
    Board Regular
    Join Date
    Sep 2008
    Posts
    57

    Default Re: Transpose

    I selected cell A2 on sheet1, clicked transpose function and listed sheet2 B3:Z3

    {=TRANSPOSE(Sheet2!B3:Z3)} This Returns VALUE? in cell A2
    Last edited by hamp; Nov 13th, 2008 at 08:51 AM. Reason: missing info

  6. #6
    Board Regular
    Join Date
    Jul 2002
    Location
    Milton Keynes, England
    Posts
    11,043

    Default Re: Transpose

    Quote Originally Posted by hamp View Post
    I selected cell A2 on sheet1, clicked transpose function and listed sheet2 B3:Z3

    {=TRANSPOSE(Sheet2!B3:Z3)} This Returns VALUE? in cell A2
    I'd say that you didn't press Ctrl-Shift-Enter. ( even though you are showing {} around the formula in your posting ). Also you are supposed to select the entire result area before entering the formula.
    Cheers, Glenn.

    Beauty is in the eye of the beer-holder.

  7. #7

    Join Date
    Feb 2003
    Location
    Gurgaon/Thrissur
    Posts
    2,615

    Default Re: Transpose

    In A2 on sheet1 and copied down,

    =IF(ROWS($A$2:$A2)<=25,INDEX(Sheet2!$B$3:$Z$3,ROWS($A$2:$A2)),"")

    HTH

  8. #8
    Board Regular
    Join Date
    Sep 2008
    Posts
    57

    Default Re: Transpose

    This worked fine for names already entered. What would be helpful is if names were continued to be entered on sheet1 in the horz position is that they would be transposed to sheet2.

    Thanks

  9. #9
    Board Regular
    Join Date
    Sep 2008
    Posts
    57

    Default Re: Transpose

    Thanks Krishnakumar .... works great!!

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


DMCA.com