Excel help

[w4ssup]

So I a set of data in excel but they're laid out horizontally and I need them to be vertical. Does anyone know to switch this?

example:
what I have
1 2 3 4

what I need
1
2
3
4

[♪~ ᕕ(ᐛ)ᕗ]

re-write it

[w4ssup]

re-write it

there is too much data, and the cells are equations and not actual digits

[♪~ ᕕ(ᐛ)ᕗ]

there is too much data, and the cells are equations and not actual digits

don't be a lazy ass, re-write it

[javalover]

there is too much data, and the cells are equations and not actual digits

See how to transpose/rotate data from rows to columns or vice versa.

[w4ssup]

See how to transpose/rotate data from rows to columns or vice versa.

It didnt work, not sure why.

[javalover]

It didnt work, not sure why.

Give me more infos. What did you try? Which version of Excel are you using?

- - - Updated - - -

How are you putting in the equations? Are you using the equation editor?

[w4ssup]

Give me more infos. What did you try? Which version of Excel are you using?

- - - Updated - - -

How are you putting in the equations? Are you using the equation editor?

Im using the 15/16 not sure which, and I tried the paste rotation like on the page. my equations are base off other cells (ex: =A1+F2) but it would return a format error, but it's what ever, I end up retyping it and dragging for the rest of the cell