Novice Challenge 7: Switcheroo

When you put data into a worksheet in Microsoft Office Excel you have some decisions to make. One big decision is how to display your data in that worksheet. For example, does it make more sense to have headers in column A with data following in the rest of the row? Or would the data be more readable if you put the headers across row 1 with the data following in the columns below?

In this challenge we decided to start with data in columns, like this:

This is nice, but what would it look like if we were to put the names and breeds reading across? Something like this:

That’s what you’re going to find out. To successfully complete this challenge, you need to take the rows and columns from worksheet 1 (Sheet1) and copy them to worksheet 2 (Sheet2) as columns and rows.

Last but not least, you need to make Sheet2 the active worksheet so you can see your results.

Important: Although we’ve formatted the data on Sheet1 to look nice, you don’t need to worry about formatting on Sheet2. As long as you turn the rows into columns and columns into rows – and make Sheet2 the active worksheet – you will have successfully completed this challenge.

When you open the Visual Basic editor (which you can do by pressing Alt+F11), there should already be a window open with the subroutine RowColumnSwap showing. Insert your code into this subroutine. (If you don’t see this subroutine, double-click on ThisWorkbook in the Project pane on the left under VBAProject (NoviceChallenge07).) Do not create any other subroutines – all your code should go in here.

Important: Do not add code to save the spreadsheet.

Submitting Your Entry

The OfficePalooza sweepstakes is over, but you’re welcome to try the challenges and learn on your own. Good luck!