update 2nd row in 1st row in excel

Question

I wanted to update contact in the same row. Both rows have the same email account, first row has no contact, second row has contact. How do I update the contact in first row.

Updated problem I used the suggested solution. But when there is not all the account has 2 rows. It will get the wrong contact. Just like ccc@gmail.com

Does this answer your question? [In Excel, how do you auto fill until next value?](https://superuser.com/questions/603318/in-excel-how-do-you-auto-fill-until-next-value) — Máté Juhász, Jun 23 '21 at 04:27
If everything is like that, use Power Query; select the Contact column, and `Fill Up` — Ron Rosenfeld, Jun 23 '21 at 14:34

score 0 · Answer 1 · answered Jun 23 '21 at 04:26

0

Follow these steps:

select column D
hit F5 or Ctrl+G to open the Go To dialog
Click Special
Tick Blanks and hit OK. Now all blank cells are selected.
without changing the selection, type a = character and hit the down arrow key. That will enter a formula that refers to the cell below.
hold down the Ctrl key and hit Enter. Now all selected cells contain a formula that refers to the cell below.
Select and copy column D, then paste as values.

answered Jun 23 '21 at 04:26

teylyn

22,498
2
40
54

Thanks for your reply. Can you take a look for my question. I have added 2 images. @teylyn. When not all the accounts have 2 rows. It will get the wrong contact. – e12345678 Jun 23 '21 at 06:24
1

Sort your data so the filled cell comes first and the rows with the blank cell comes after that. Then use my approach, but use the UP arrow instead the DOWN arrow. That will work. – teylyn Jun 23 '21 at 09:38

score 0 · Answer 2 · answered Jun 23 '21 at 08:42

0

You can use another column with the formula below. Drag it down to fill the other cells.

=IF(AND(ISBLANK($D2),$C2=$C3),$D3,$D2)

Note that if a contact number is blank, it will appear as a 0.

answered Jun 23 '21 at 08:42

Reddy Lutonadio

17,120
4
14
35

update 2nd row in 1st row in excel

2 Answers2