Once you press Ctrl Shift Enter Excel will surround your Transpose formula with curly braces that are visible in the formula bar and are a visual indication of an array formula. So click on the Formula button. With the range highlighted in the upper left cell type the following formula.
Under Paste Options click Paste Special Check the box next to Transpose and then press the OK button.
Now if we change any data in the original range the transposed range will change as well. But make sure to select the same number of cells as the original set of cells but in the. Unfortunately I can get these formulas to transpose properly to a column to make it useful. But instead of hitting ENTER hit CTRL-SHIFT-ENTER.