Make more cells with duplicate names and new phones

See the attache file with the result in green.

I used Vlookup twice to get the result of the Phone number.

d1 =IFERROR(INDIRECT(ADRESS(IF(MOD(ROW(),3)=0,INT(ROW()/3),1+INT(ROW()/3)),COLUMN()-3)),"") and drag down.

e1 =IFERROR(VLOOKUP(COUNTIF($D$1:$D1,$D1),$K$2:$L$4,2,0)&VLOOKUP($D1,$A$1:$B$3,2,0),"") and drag down.

show the expected result manualy>

What is 4 30?

and what did you tried yourself to get this anwer (on the second question)?

I asked this because this needs a whole differant approach for column D.

You now need to duplicate 4 times instead of 3 (in your earlies question).

d1 =IFERROR(INDIRECT(ADRESS(IF(MOD(ROW(),4)=0,INT(ROW()/4),1+INT(ROW()/4)),COLUMN()-3)),"") and drag down.

e1 =IFERROR(VLOOKUP(COUNTIF($D$1:$D1,$D1),$K$2:$L$10,2,0)&VLOOKUP($D1,$A$1:$B$3,2,0),"") and drag down. (after adding the new data in the table).

Here is a copy of oeldere's file which has updated formulas applied.
Let us know if you have any questions.