I'm really not clear on this question but lets suppose you have numbers in
B1:B12. In an empty cell type =TRANSPOSE(B1:B12). Then highlight the
formula on the formula bar and press F9, Enter.
But is this really what you are asking? give us an example of "before" and
"after"