Let us first ensure you performed the procedure correctly:
A1:C20 is a 20x3 matrix. Hence its transpose will be a 3x20 matrix.

Select a 3-row by 20-column area. In the formula bar enter

=TRANSPOSE(A1:C20)

Commit with Shift+Ctrl+Enter.

Does this work?
Kostis Vezerides

On Jun 7, 5:15 pm, "Mike G" wrote:
Greetings...I have a list of addresses in a1:c20 in the format a1=name
b1=street c1=city state and I want to transpose them into a vertical
alignment with a possible empty row between them. Used formula
=transpose(a1:c20), did f2 and ctrl+shift+enter and result is value#. any
help appreciated.