Excel - IF Function Problem - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

Not sure what this called to properly search so I am struggling. I import reports into Excel and get A1 with a name and A2 is blank. Then the following cells come in 2 rows that belong to the name at A1. If I want to sort by name, A2 is blank so I can't keep all of row 1 & 2 info together. Is there a way to say if A2 is blank, copy info from A1? I have 160 pages of this data so I can't just copy and paste individually.
Solved by B. H. in 17 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 11/09/2018 - 08:19
Excelchat Expert 11/09/2018 - 08:19
User 11/09/2018 - 08:19
Excelchat Expert 11/09/2018 - 08:20
Can you please show me a few sample data?
User 11/09/2018 - 08:20
Yes, 1 moment
Excelchat Expert 11/09/2018 - 08:21
Thank you.
User 11/09/2018 - 08:23
[Uploaded an Excel file]
Excelchat Expert 11/09/2018 - 08:25
In the example file, A2 should be Mary and A4 should be John, right?
User 11/09/2018 - 08:25
Excelchat Expert 11/09/2018 - 08:26
Yeah, we can do it at once.
Excelchat Expert 11/09/2018 - 08:27
Here are the steps required.
Excelchat Expert 11/09/2018 - 08:28
Before we start, please open a excel file on your computer and try to apply the steps as I'm giving them. How does that sounds?
User 11/09/2018 - 08:28
good, got it
Excelchat Expert 11/09/2018 - 08:28
1. Select the range that contains blank cells you need to fill. Let me know when you are done.
User 11/09/2018 - 08:29
Like a2 and a4 or all the info?
Excelchat Expert 11/09/2018 - 08:30
The whole column A.
User 11/09/2018 - 08:30
ok, got it
Excelchat Expert 11/09/2018 - 08:30
2. Click Home > Find & Select > Go To Special…, and a Go To Special dialog box will appear, then check Blanks option.
User 11/09/2018 - 08:31
Excelchat Expert 11/09/2018 - 08:31
3. Click OK, and all of the blank cells have been selected. Then input the formula =A1 into active cell A2 without changing the selection.
Excelchat Expert 11/09/2018 - 08:31
4. Press Ctrl + Enter, Excel will copy the respective formula to all blank cells.
User 11/09/2018 - 08:32
wow, just what I needed!
Excelchat Expert 11/09/2018 - 08:33
I great to hear that you were able to do it. That is truly brilliant.
User 11/09/2018 - 08:33
You are awesome! and I appreciate you
Excelchat Expert 11/09/2018 - 08:34
Usually it takes more attempts if you are doing it for the first time. But you did it brilliantly.
Excelchat Expert 11/09/2018 - 08:34
Anything else you need?
User 11/09/2018 - 08:34
Your knowledge is wonderful but nothing else
Excelchat Expert 11/09/2018 - 08:35
Please remember we wrote =A1 because A1 is the first cell with info that we wanted to use in the first empty cell A2.
User 11/09/2018 - 08:35
I will be using this often!
Excelchat Expert 11/09/2018 - 08:35
So if it were A3 is the first empty cell and we wanted to fill it with the value at A2, then we would have to write =A2
User 11/09/2018 - 08:35
Do I just hit end session?
Excelchat Expert 11/09/2018 - 08:36
Yeah, if nothing else is needed.
Excelchat Expert 11/09/2018 - 08:36
Thank you and have a great day!
User 11/09/2018 - 08:36
Have a spectacular day
Excelchat Expert 11/09/2018 - 08:36
Also please do rate me 5 star if you thing I have earned it.

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.

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.

Click here to get your free Excelchat help session

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
The Allstate Corporation
United Parcel Service
Dell Inc