TRANSPOSE formula problem

[nholmes]

I'm not sure what I'm doing wrong, but I am trying to use the transpose formula to transpose row data to column headings and I only get the first cell of the row data to come over to the column headings. Is there something I'm missing here? Please Help!!

 

[Marc]

Just messed with this for the first time myself. It has to be entered as an array formula (CTRL+Shift+Enter)

Hightlight the cells where you want the transposed data and then type the formula, then (CTRL+Shift+Enter).

HTH

Edit to add:
TRANSPOSE must be entered as an array formula in a range that has the same number of rows and columns, respectively, as array has columns and rows

 

[Aladin Akyurek]

I'm not sure what I'm doing wrong, but I am trying to use the transpose formula to transpose row data to column headings and I only get the first cell of the row data to come over to the column headings. Is there something I'm missing here? Please Help!!

Why don't you state your problem in more specific terms like transfer/link A2:A10 to B1:K1?

 

[Binosh]

I have faced the same problem , there are so many helping articles are the internet , non of them shows the correct procedure ; the real problem was… select all the equal range of cells and add the formula in the formula bar and CTRL + Shift + Enter, that is it!!!