-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Transpose
- Thread starter hamp
- Start date
Richard Schollar
MrExcel MVP
- Joined
- Apr 19, 2005
- Messages
- 23,707
Are you tryingto do this using the TRANSPOSE formula? What is the formula if so?
Upvote
0
GlennUK
Well-known Member
- Joined
- Jul 8, 2002
- Messages
- 11,871
- Office Version
- 2019
- 2013
- Platform
- Windows
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.
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.
Upvote
0
Colin Legg
MrExcel MVP
- Joined
- Feb 28, 2008
- Messages
- 3,507
- Office Version
- 365
- Platform
- Windows
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
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
Upvote
0
GlennUK
Well-known Member
- Joined
- Jul 8, 2002
- Messages
- 11,871
- Office Version
- 2019
- 2013
- Platform
- Windows
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.
Upvote
0
Krishnakumar
Well-known Member
- Joined
- Feb 28, 2003
- Messages
- 2,615
In A2 on sheet1 and copied down,
=IF(ROWS($A$2:$A2)<=25,INDEX(Sheet2!$B$3:$Z$3,ROWS($A$2:$A2)),"")
HTH
=IF(ROWS($A$2:$A2)<=25,INDEX(Sheet2!$B$3:$Z$3,ROWS($A$2:$A2)),"")
HTH
Upvote
0
Similar threads
- Solved
