View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Rob Rob is offline
external usenet poster
 
Posts: 718
Default Formuala Question



"Rob" wrote:

ADDITIONAL DATA TO CONFIRM MY QUESTION:

Here is my data - need the results to alternate columns:

Column A Column B
7 R
9 C
8 J

How do I get this to populate in column C:
7 (A1)
R (B1)
9 (A2)
C (B2)
8 (A3)
J (B3)


THANKS!
Rob