# Thread: Transpose Thanks: 0 Likes: 0

1. ## 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. ## Re: Transpose

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

3. ## 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.

4. ## 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. ## 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

6. ## Re: Transpose

Originally Posted by hamp
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.

7. ## 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. ## 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. ## Re: Transpose

Thanks Krishnakumar .... works great!!

## User Tag List

#### Posting Permissions

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