put row/column transpose in obvious place, like DATA -Transpose (.

[Guest]

Excel does have the capacity to transpose data in rows to data in columns.
But when I looked for this capability, I found information on the
"transpose" function. It made little sense and didn't do what I wanted.
Finally, I looked in the Lotus help, and found it under Range, Transpose.
Then Excel explained how to do it.
I suggest that Excel make the row to column (and column to row) transpose
feature more visible, by putting it in a more intuitive place, say under
DATA. I should be able to highlight a range, then choose to transpose
(switch rows and columns) and put it where I want it. It should be easier
and intuitive.

 

[Frank Kabel]

Hi
if this is a feature request post it directly to Microsoft:
(e-mail address removed)


This here is a peer-to-peer newsgroup and most of all posters are not
MS employees

 

[hgrove]

Edwardxa12 wrote...

Excel does have the capacity to transpose data in rows to data i columns. But
when I looked for this capability, I found information on th "transpose" function.
It made little sense and didn't do what I wanted. Finally, I looked i the Lotus
help, and found it under Range, Transpose. Then Excel explained how t do it.
I suggest that Excel make the row to column (and column to row transpose
feature more visible, by putting it in a more intuitive place, sa under DATA. I
should be able to highlight a range, then choose to transpose (switc rows and
columns) and put it where I want it. It should be easier an

intuitive.

The TRANSPOSE worksheet function *DOES* do what you claim to want t
do, but in a dynamic way. That is, if the data in the source rang
changes, so will the calculated values in the transposed destinatio
range. If you had

a 1 b
2 c 3

in A1:C2, and you selected E1:F3 and entered the array formula

=TRANSPOSE(A1:C2)

you'd get the result

a 2
1 c
b 3

Looks like the transpose to me. This isn't what you wanted?

Granted the location of the static transpose as the Transpose option i
the Paste Special dialog isn't obvious if you consider this a dat
manipulation operation, but transpose operations like 123's /RT are, i
essence, copy and paste operations, and there *is* an entry for this i
Excel's online help. Since there is a TRANSPOSE worksheet function, th
existence of Edit > Paste Special, Transpose is more of an unnecessar
convenience than core feature. If it's hidden away, no big deal.

Putting this in the Data menu would be consistent with 123, but it'
unclear that would be beneficial to anyone other than ex-123 users. I
you really want it there, write a macro like the following in you
Personal.xls file


Code
-------------------
Sub myxpos()
'assign this to a keystroke combination like [Ctrl]+[Shift]+T
Dim tf As Boolean

If Application.CutCopyMode <> xlCopy Then
MsgBox Title:="Transpose", _
Prompt:="You must *copy* a range into the clipboard in order to " & _
"transpose it."
Exit Sub
End If

tf = (TypeOf Selection Is Range)
If tf Then tf = (Selection.Cells.Count = 1)
If Not tf Then
MsgBox Title:="Transpose", _
Prompt:="You must select the top-left cell of the range in which the " & _
"transpose of the data in the clipboard will be stored."
Exit Sub
End If

On Error GoTo CleanUp

ActiveCell.PasteSpecial Paste:=xlPasteAll, Transpose:=True
Application.CutCopyMode = False
Exit Sub

CleanUp:
MsgBox Title:="Transpose", _
Prompt:="Error " & Format(Err.Number) & ": " & Err.Description
End Su
-------------------


and use Tools > customize to insert an entry in the Data menu to ru
this macro. You can have what you want, and those who'd prefer Exce
didn't look like 123 could have what they want