Formula to populate the rows

R

redJohn89

New member
Joined
Jul 12, 2016
Messages
8
Reaction score
0
Points
0
Hi Guys,

In my sheet there are two columns A(my current scenario) and B(the actual output that i need). How can i make col A look like col B? What would be the correct formula?
 

Attachments

  • Question.xlsx
    8.5 KB · Views: 17
If your goal truly is to have Column A look like the formula output from Column B, you would need to copy Column B output and Paste Special, "Values" into Column A, then delete the helper column B.
 
Another way to fill in the "blanks" in column A is this
1) Select Column A
2) Press the F5 and click Special
3) Click Blanks
4) Press the = sign and then the Up Arrow key once
5) A formula will appear
6) Finish by pressing CTRL+ENTER
7) All the cells will be filled.
8) Now copy the range and paste as value.
Hope this helps
 
Last edited:
You must log in or register to reply here.
Back
Top