Copy Data from a source to the blank space

[datastudent]

Hi,

How can I copy the data from "AAA" to "Fixed" and "Mobile" columns?

The principle is as follow:
1. If Fixed or Mobile or both are blank, copy data from AAA.
2. If AAA and Fixed are blank, copy data from Mobile to Fixed.
3. If AAA and Mobile are blank, copy data from Fixed to Mobile.
(AAA does not necessarily need to be filled)

Table 2 is the expected result.

Template_v1.xlsm
	F	G	H	I	J	K	L	M	N
1	Country	AAA	Fixed	Mobile		Country	AAA	Fixed	Mobile
2	ALBANIA		0.12	0.3718		ALBANIA		0.12	0.3718
3	ANGOLA			0.14		ANGOLA		0.14	0.14
4	ARGENTINA	0.01		0.0261		ARGENTINA	0.01	0.01	0.0261
5	ARMENIA	0.1733				ARMENIA	0.1733	0.1733	0.1733
6	AUSTRALIA	0.0252	0.011	0.0252		AUSTRALIA	0.0252	0.011	0.0252
iBASIS_Outbound

 

[Sam_D_Ben]

Something like this,

Book1
	A	B	C	D	E	F	G	H	I
1	Country	AAA	Fixed	Mobile		Country	AAA	Fixed	Mobile
2	ALBANIA		0.12	0.3718		ALBANIA		0.12	0.3718
3	ANGOLA			0.14		ANGOLA		0.14	0.14
4	ARGENTINA	0.01		0.0261		ARGENTINA	0.01	0.01	0.0261
5	ARMENIA	0.1733				ARMENIA	0.1733	0.1733	0.1733
6	AUSTRALIA	0.0252	0.011	0.0252		AUSTRALIA	0.0252	0.011	0.0252
Sheet1

Cell Formulas
Range	Formula
H2:H6	H2	=IF(C2="", IF(B2<>"", B2, IF(D2<>"", D2, "")), C2)
I2:I6	I2	=IF(D2="", IF(B2<>"", B2, IF(C2<>"", C2, "")), D2)