<cfsilence>

Excel Tip - Convert A Row To Column

Posted At : January 15, 2007 8:44 AM | Posted By : todd sharp
Related Categories: Excel Tips

It's Monday morning so I'll start off with an easy one. I used to consider myself an advanced Excel user, but ever since I learned the beauty of relational databases I find myself using Excel much less than I used to. That being said I found myself with a issue this morning. It sounds like a simple issue (and it is really) but it was something that I never found myself needing to do before. I simply needed to take a row of data and convert it to columnar form. I could have copy/pasted the values one by one or devised a quick easy formula to do this but I figured there had to be a much easier way to do this. Sure enough there is. Highlight your target row (or column, it works both ways) and copy the data. Right click on your destination cell and select Paste Special. In the paste special dialog box check 'Transpose' and thats it. A simple row to column conversion.

Comments (8) |

Print |

Send |

del.icio.us |

Linking Blogs | 5256 Views

Comments

[Add Comment]

Thanks!!! Firsts search on Google for " Excel "row to column' " .

# Posted By Chris Clarke | 1/18/07 2:29 AM

Nice tip. Many thanks

# Posted By Eklipse | 2/6/07 6:26 AM

what a smart ass... i did that first and it brought me here.... so is this possible or are there more ignorant posters here?

# Posted By Matty | 2/28/07 1:40 PM

transpose is great, but how about a series of data in a row like this 3 row data in 3 column...

a1
a2
a3
a4

b1
b2
b3
b4

c1
c2
c3
c4

in 1 copy and paste special then transpose????....

# Posted By marcouis | 4/3/07 3:34 AM

You can do a whole table with the Transpose function - this is great info!

# Posted By Neil Schunke | 4/3/07 2:48 PM

That was a great info buddy! Solved a real big task at hand in no time!

# Posted By Ravikant Ankala | 7/4/07 1:27 AM

You don't know how many times I have tried this with a formula and could not figure it out!!! Thank you!

# Posted By Sherie | 10/5/07 10:00 PM

This saved me a LOT of time today and I have you to thank for that! Great tip that I know I will be using again and again. Thanks!

# Posted By Chris | 10/30/07 8:24 AM

[Add Comment]