For F5, the cell is already using concatenate but here's what I'm wanting to do. I want F5 to contain information from the 2nd row (i.e. 35% and 11/13/2010). However, when i copy and paste the formula from F1 to F5, F5 registers the values contained in C5 and D5 and not the values on C2, and D2). Any help please.


Pls see the attached picture.