Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Turn Rows into Columns in Excel

Have you ever had to take a long column of data in Excel and turn it into a column? There are several ways to do this but lately I have been using a new PASTE feature to do this.Here’s how it works.

1. Take a long row of data as shown below.

image

2. Select and Copy the Row

3. Then Right-Click and Find the “Paste Special” items

image

4. Select the 4th option from the left (Paste Transpose) and watch what happens.

5. Taa Daa !

image

 

Until then – SELECT ‘Stay classy ’ + @YourCityWhereverYouAre +’.’

Want to stay connected to all the coolest SQL, SharePoint, BI and DBA content around? Then stay involved with the SQL Community here:

Twitter – @Adam_Jorgensen

Blog – My Blog is here…

SQL Lunch – Check out our weekly FREE SQL Food!

SQL PASS – Get connected with the Community Organization for SQL Server

SQL Rally – Coming in May !!Register

Comments

No comments.

Leave a Comment

Please register or log in to leave a comment.