#Office365Challenge – Ever need to change data in Excel displayed as columns to rows? No retyping necessary. This is very easy to accomplish with Paste Special – Transpose.

Day: 19 of 365, 346 left
Tools: Microsoft Office; Excel 2013
Description: How to transpose data using Paste Special

All you have to do is select the data (1), Copy (2), Right-click > Paste Special (3), Transpose (4). And voila!! (5).

Transpose 1

It is also possible to copy and paste tables of data in the same way:

Transpose 2

Overview of my challenge: As an absolute lover of all things Microsoft, I’ve decided to undertake the challenge, of writing a blog every single day, for the next 365 days. Crazy, I know. And I’ll try my best, but if I cannot find something good to say about Office 365 and the Tools it includes for 365 days, I’m changing my profession. So let’s write this epic tale of “Around the Office in 365 Days”. My ode to Microsoft Office 365.

Keep in mind that these tips and tricks do not only apply to Office 365 – but to the overall Microsoft Office Suite as well as where applicable, SharePoint.