Tuesday Tip: “Excel – Swap Columns & Rows with Ease”

by Richard Stokes

This week’s tip comes courtesy of our NOC Manager, Steve Guthman – I do have to give credit where credit is due.

Spreadsheets, spreadsheets, spreadsheets………..We all use them, some of us more than others and I think it’s safe to say that most of us only use about 10% of what Excel is actually capable of doing.

So, let’s say you’re the administrator for a medical practice and after hearing Penny Noyes’ presentation at the North Fulton MGMA’s January 2013 educational session you want to create a spreadsheet to track all of your payer contracts.  You’ve just spent 15 minutes creating a table in Excel and you suddenly decide that it’s going to work better if the columns and rows were swapped and all the data along with it.  Here’s what you do:

1)      Highlight the table you’ve created and copy it.

2)      Select either a blank cell somewhere on your existing spreadsheet or open a new spreadsheet.

3)      Right click that cell with your mouse and a menu pops up with some ‘paste options’.

4)      Move your mouse down to ‘paste special’ and left click it with your mouse.

transpose-paste-option-with-arrows

5) Another menu pops up and in the bottom right you will see an option to select ‘transpose’.  Check the box and click ‘OK’

transpose-menu-with-arrow

transposed-spreadsheet

Your new ‘transposed’ spreadsheet will suddenly appear and you just saved yourself a lot of time.  As you can see – you’ll need to work with some of the formatting as not all of that comes over during the process.  In the grand scheme of things though that’s the least of your worries compared to recreating the table from scratch.

Richard Stokes Headshot

Richard Stokes: As the Director of Sales for Network 1, Richard identifies “future” clients that can benefit from the support of an experienced, outsourced IT team. He helps clients and prospects find technology solutions they need to achieve better productivity and efficiency so they can focus on making money and growing their businesses.

Network 1 designs, builds and supports the IT you need to run your business more securely, productively and successfully. Whether you want to outsource all of your IT needs to a reliable, responsive, service-oriented company, or need to supplement the work of your internal IT staff, we will carefully evaluate where you are now, discuss where you want to go and implement and support a plan to get you there with as little interruption as possible.

Leave a Comment





Related Posts