**Question description:**

*This user has given permission to use the problem statement for this blog.*

Two columns of data, trying to fill in the blanks in the second column. Example:
A = B
A = Blank
A = B
C = D
C = D
C = Blank
C = D

Solved by S. Q. in 11 mins

This is the chat thread from the real Excelchat help session. It contains no private user information.

Excelchat Expert
07/06/2018 - 05:13

Hello

User
07/06/2018 - 05:13

Hi

Excelchat Expert
07/06/2018 - 05:13

Welcome to excelchat

Excelchat Expert
07/06/2018 - 05:14

I want to understand the problem clearly, can you please explain it once again by showing some sample data in the preview window?

User
07/06/2018 - 05:14

I can't show example due to the confidential nature of the data, but I will try to explain using the window

User
07/06/2018 - 05:15

Trying to fill in the blanks with the missing data

Excelchat Expert
07/06/2018 - 05:16

Meaning Bob Smith will be filled with 12345 in B3?

User
07/06/2018 - 05:16

Right

User
07/06/2018 - 05:16

Susan will be filled in with 34567

Excelchat Expert
07/06/2018 - 05:17

Okay, understood.

Excelchat Expert
07/06/2018 - 05:17

For this, the data need to be in sorted order.

User
07/06/2018 - 05:17

Column A is already sorted in alphabetical order

Excelchat Expert
07/06/2018 - 05:18

Great.

Excelchat Expert
07/06/2018 - 05:18

Please see column C.

Excelchat Expert
07/06/2018 - 05:19

In C1, the formula is =B1. This is the first row.

Excelchat Expert
07/06/2018 - 05:19

Then in C2 the formula is =IF(B2="",C1,B2)

Excelchat Expert
07/06/2018 - 05:19

We can drag this formula down to fill in the empty cells.

Excelchat Expert
07/06/2018 - 05:20

Please let me know if you have any question.

User
07/06/2018 - 05:21

Trying it now

Excelchat Expert
07/06/2018 - 05:21

Okay, I'm here if you need me.

User
07/06/2018 - 05:22

Wow, I think that worked!

Excelchat Expert
07/06/2018 - 05:22

Great.

Excelchat Expert
07/06/2018 - 05:22

Anything else?

User
07/06/2018 - 05:23

I don't think so. Thank you so much

Excelchat Expert
07/06/2018 - 05:23

In that case, the session will end in 9 minutes unless you opt to end it now.

User
07/06/2018 - 05:24

I think we're good. Thanks again

Excelchat Expert
07/06/2018 - 05:24

Thanks for visiting excelchat, have a great day.

User
07/06/2018 - 05:24

You too

**This is the output file from the real Excelchat help session:**

*This is an example of the expert help you can get. It contains no private user information.*