If Cell in column B is empty, do not copy. Otherwise copy respective cell in Column A

[pelbert]

Hello Forum magicians...
I am currently having a mental block on creating a formula that will accomplish my goals.

I am needing a formula in column C that will look at respective cells in Column B. If the cells in Column B are empty, then return nothing. If the respective cell in Column B have data, then return respective data from cell in column A. Otherwise, return a blank if empty.

Please see attached example.

Thank you for any help you can provide at this time. I am sure that one day all of these questions I ask will sink in and I will be able to return the favor to someone else.

[ORoos]

Try: =IF(B2="","",A2)

[pelbert]

That's it! I do not know why I could not think of this...however, your awesome fast response is greatly appreciated. Thank you so very much. You are awesome.