Help on a formula.. Fill up the cell

[Suryaprasad]

SC_12
SC_45

<tbody>
</tbody>

I want to fill value SC_12 to the below 2 rows and SC_45 the same. somebody can help me with a formula please.
I have more than 10000 data in the same manner and i want to fill up the cell with the above data. Its making my work tooo hard i want a formula to fill it please

 

[wigi]

For instance, Google on:

excel fill blanks with value above

and you will find plenty of webpages illustrating this.

 

[PaddyD]

Or, to save you the effort (and keep the answer on the board):

1) select all the data, starting at the top - let's assume your first data cell is a1
2) go to - edit | go to | special - blanks
3) stick the cursor in the formula bar and enter =a1
4) hit alt +enter
5) select all the data again, then copy | paste special - values over it to fix the values

EDIT - take note of comments below re point (4)

 

[wigi]

Or, to save you the effort (and keep the answer on the board):

1) select all the data, starting at the top - let's assume your first data cell is a1
2) go to - edit | go to | special - blanks
3) stick the cursor in the formula bar and enter =a1
4) hit alt +enter
5) select all the data again, then copy | paste special - values over it to fix the values

I would assume that there is also - at least minimal - effort from the OP.

I see some advantages of having this information on the board, but reinventing the wheel isn't very clever...
Certainly not if errors are introduced: step 4 should be Ctrl-Enter instead of Alt-Enter.

Webpages can be updated/extended, static forum posts can't

 

[PaddyD]

"I would assume that there is also - at least minimal - effort from the OP"

An often bold assumption.

"Certainly not if errors are introduced..."

Oops. Forgot - I'm on a MAC, which is happy with either.

"Webpages can be updated/extended, static forum posts can't"

The joys of MOD privileges (see above).

 

[wigi]

Thanks for the modification

Rephrasing my first sentence:
"I would assume that there should also be - at least minimal - effort from the OP"
"Is" changed to "should be".

 

[Suryaprasad]

Or, to save you the effort (and keep the answer on the board):

1) select all the data, starting at the top - let's assume your first data cell is a1
2) go to - edit | go to | special - blanks
3) stick the cursor in the formula bar and enter =a1
4) hit alt +enter
5) select all the data again, then copy | paste special - values over it to fix the values

EDIT - take note of comments below re point (4)

Thanks a lot.. I got answer from google and finished it.. I filtered blank cells in excel and used formula as (if=A2<>"",A2,0).. (Copy & paste in all blank cell)
This worked out and made and work easy..

Thanks for the help guys..
i need to learn excel soon