Quick Excel question...

[Turkish]

I wouldn't post it in Offtopic if it wasn't urgent but we are going to send some client data over and they sent a last-second request to convert to data in columns into rows... can anyone help me? Thanks (and again, sorry for posting in the wrong forum 🙁 )

Example:

Cities
Alexandria
Arlington
Mclean
Reston
Vienna

trying to convert that to

Alexandria Arlington Mclean Reston Vienna

Thanks!

 

[Turkish]

Nevermind, checked out Microsoft's page for Excel and its in the TIPS section 🙂

 

[milehigh]

I believe its called TRANSPOSE.

 

[tw1164]

you can use paste special ->transpose

 

[Turkish]

thanks fellas, i had already found it on microsoft's page, but thanks regardless for responding.