Excel help

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

Originally Posted by ♪~ ᕕ(ᐛ)ᕗ

re-write it

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

Originally Posted by w4ssup

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

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

Originally Posted by w4ssup

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.

Originally Posted by javalover

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

It didnt work, not sure why.

Originally Posted by w4ssup

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?

Originally Posted by javalover

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

Excel help

Post a Reply

Similar Threads

Tags for this Thread