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
Hello
Excelchat Expert
11/09/2018 - 08:19
Welcome
User
11/09/2018 - 08:19
hello
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
Yes
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
done
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.