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.
2. Select and Copy the Row
3. Then Right-Click and Find the “Paste Special” items
4. Select the 4th option from the left (Paste Transpose) and watch what happens.
5. Taa Daa !
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!