Sometimes it's the simplest things that leave me completely stymied. Often, for example, I will copy data into Excel and wish it was arranged horizontally rather than vertically. Usually, I will painstakingly copy the fields from their single column into a single row. Recently, I discovered what should have been obvious -- there's a single click way to do this automatically.
As Productivity 501 points out in a short 1-minute tutorial video, it's a simple matter of using the Paste Special command. Here's how:
That's it. Personally, I have never seen this dialog box before; I've always just chosen items from the Paste Special fly out menu. Hopefully this will save you as much time as it has saved me since discovering this little gem.
- Copy the cells that you want to transpose, either from a column to a row or from a row to a column.
- Click the cell where you'd like to start pasting the new column or row.
- Right-click and choose Paste Special.
- In the Paste Special dialog box, click Transpose and then click OK.
More on BNET: