Question regarding copying rows.

Hey guys,

So I am taking an introduction to Excel class at the local community college and the professor gave us an exercise that I can't figure out. Any and all help will be appreciated.

The Scenario:
This Excel sheet is to be used by a real estate investor who will be purchasing one $2,000,000 building every year for the next 20 years. He finances the entire $2 Mill, paying 4% interest on every purchase and earning 4% appreciation on every building every year. We need to build an Excel sheet that would show his equity buildup over the years.

My Idea
Attachment 518062

I thought I could just copy the contents of Row#2 down while skipping one additional column every time but I can't figure out how to do it efficiently.

For example: My data is in columns A2:AD2 and I want to copy it to B3:BE3 and then to C4:CF4 followed by D5:DG5 and so on 20 times. Is there an automatic way to do this or do I just have to manually enter the data over and over again?

Also, this can not be the best way to present this data - what if I need a 100 rows! It would be impossible to print. Can you guys suggest a better way to get a similar result? Like is there any way to use charts etc?

Thanks again.

You can use the row and the Mod functions and ignore all Even Rows or All odd rows.

Formula:

=MOD(ROW(),2)

so

You could try this for Odd Rows

Formula:

=if(MOD(ROW(),2)=1,A$1,"")

Or

Formula:

=if(MOD(ROW(),2)=0,A$1,"")

For Even rows.

Paste the formula into B2 and copy down.