I use multiplication tables to give new users a sense of the power of mixed
absolute and relative references; with a row of numbers along the top and a
column along the side, a single formula can easily produce the table.

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.

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.

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