Excel Tip - Convert A Row To Column

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 (10) | Print | Send | del.icio.us | Linking Blogs | 6730 Views