Formula to create two-sided flash card

[maizen]

Hello,

I am in need of your expertise. I am a basic Excel user. I am making flash cards for students to learn state capitals. I have states in one column and corresponding capitals in next column. I am going to merge these into a Publisher Document that will make the flash cards.
example:

<TABLE cellPadding=2 width=250 border=1><TBODY><TR><TD>State </TD><TD>Capital</TD></TR><TR><TD>Alabama </TD><TD>Montgomery</TD></TR><TR><TD>Alaska </TD><TD>Juneau</TD></TR><TR><TD>Arizona </TD><TD>Phoenix</TD></TR><TR><TD>Arkansas </TD><TD>Little Rock</TD></TR><TR><TD>California </TD><TD>Sacramento</TD></TR><TR><TD>Colorado </TD><TD>Denver</TD></TR></TBODY></TABLE>

The problem I have is that when I print out the back side of the card it displays the wrong capital. Alabama ends up with Juneau and Alaska has Montgomery. When the front side with the states is flipped over the image becomes reversed. The capitals need to be reversed on the spreadsheet so that they correspond to the right state when they are printed on the back of the card. I'm also going to be using this for world geography. So it would be great to have formula rather than reversing them each manually.

Thanks for your input.

 

[drsarao]

Maizen,
you didn't write about what happens to other capitals in the list.
I am assuming the words have to be flipped on alternate rows.
Try this:

Excel Workbook
	A	B	C	D	E
1	State	Capital		State	Capital
2	Alabama	Montgomery		Alabama	Montgomery
3	Alaska	Juneau		Juneau	Alaska
4	Arizona	Phoenix		Arizona	Phoenix
5	Arkansas	Little Rock		Little Rock	Arkansas
6	California	Sacramento		California	Sacramento
7	Colorado	Denver		Denver	Colorado
Sheet1

Excel 2003

Cell Formulas
Range	Formula
D2	=IF(MOD(ROW(),2),B2,A2)
E2	=IF(MOD(ROW(),2),A2,B2)

Now instead of picking data from col A-B, pick from col D-E.
The formulas can be entered on the 2nd row then copied down.
HTH