Twice in the last month I’ve needed to take a single column of data (listed in rows) and make them a single row of multiple columns. It turns out there is an easy way to do this, but I keep forgetting it. I keep looking for the option on the Ribbon, but it’s not there. The feature is buried as part of the “Paste Special” functionality. For example, let’s say I have some data that looks like this:

Jonathan Medd is producing a blog series called “One Cmdlet at a time”, which focuses on new cmdlets in PowerShell 2.0. If you are interested in PowerShell you should check out this series.

David Giard will setting up a pair programming event in Detroit next Wednesday, December 16th. If you are interested in learning what pairing is all about and meeting new people, check it out. You can find more information over at Dave’s Blog: http://www.davidgiard.com/2009/12/08/PairProgrammingEvent.aspx