What exactly {=TRANSPOSE()} means

[T. Valko]

It is a function that will make a vertical range horizontal or make a
horizontal range vertical.

1
2
3
4
5

Becomes:

1 2 3 4 5

And

1 2 3 4 5

Becomes

1
2
3
4
5

 

[Shane Devenshire]

Hi,

And the outer {}'s indicate to Excel that you entered the formula as an
array, so Excel should be prepared to return multiple answers based on a
single formula.

In other words if your formula reads {=TRANSPOSE(A1:A5)} and you select
B1:F1 and then enter the formula by pressing Shift+Ctrl+Enter the formula
will display the contents of A1:A5 across the row.

If you enter the formula in a single cell and copy it, it will not work. If
you enter it in all the cells but don't do it as an array (Ctrl+Enter) that
won't work either.

The outer {}'s are never typed, they appear automatically when you press
Shift+Ctrl+Enter to enter the formula. Inside a formula you may type them to
indicate a portion of a formula is an array.