Sure: Your original data starts in cell A2 (student ID). In cell E2 you'll see the formula: =IF(A2<>"",A2,E1) which means "if cell A2 is not blank, then display whatever is in A2; If it is blank then display whatever is in the cell directly above it". In this way the data is displayed correctly as you copy the formula on down to the bottom. Same method in cell F2. Cell G2 is simply whatever is in cell C2. That help?
|