carlmanaster wrote...
....
But sometimes I don't want to copy/paste-special-transpose to produce
the
source row from the source column. I'd like a new symbol, let's say
"%", to
mean "transpose-relative" as "$" means "absolute". So if my source
was in
A1:A10, I could put "=$A1*$A%1" into B1, fill right and down, and be
done.

Wouldn't you need your source column in A2:A11 in order for there to be
room in row 1 to hold the source row in B1:K1? Once that correction to
your specs is made, you could use =OFFSET($A$1,COLUMN()-1,0) in B1 and
fill right. Or you could select B1:K1 and enter the array formula
=TRANSPOSE(A2:A11).

The "%" would mean that as the formula's _column_ changes, the _row_
of the
reference changes, or vice versa if the % precedes the column
reference.

And you expect this to be easier for new users to understand?

Unfortunately, Excel is not APL, so no A jot-dot-times A. But also not
so bad *IF* you use array formulas. Select B2:K11 and enter the array
formula

=A2:A11*TRANSPOSE(A2:A11)

Perhaps not straightforward, but also not rocket science.

For extra credit, make double-clicking the grow-handle of such a cell
expand
to the appropriate square and fill along both axes.

If you want extraneous functionality, there are several open source
spreadsheets you could modify to satisfy your whims. Earn your own
extra credit.