Suppose you have data like below and you want to fill in blank rows with data with non blank row up. Here, in range A3:A5, you want value A to appear, in range B7:B9, you want value B to appear and so on.
You need this kind of situation, mostly, when you are making pivot which demands that all rows should have the data.
You need to follow following steps –
1. ALT+EGSK and Enter. This will select all your blank cells.
2. Type "=" (without double quotes) and press up Arrow.
3. CTRL+Enter
Now you will have cells filled as you wanted. You will notice that those blank cells are carrying the formula = A2, =A3 etc.
4. To convert them to static values, select you column A, Copy and Paste Special Values.