Merge Two Tables In To One Using Formula

[mahmoud-lee]

I want to merge (Table 1) with the table (2) and the result (Table 3)
And I hope will be answered by formulas
I am using Office 2003

[Admin]

Hi,

if there is no blank cells in at least column B, this will do the trick.

B23 and copied down & across,

=IF(ROWS(B$23:B23)<=COUNTA($B$4:$B$8)+COUNTA($B$14:$B$18),INDEX(($B$4 :$F$8,$B$14:$F$18),IF(ROWS(B$23:B23)<=COUNTA($B$4:$B$8),MOD(ROWS(B$23:B23)-1,COUNTA($B$4:$B$8)),MOD(ROWS(B$23:B23)-COUNTA($B$4:$B$8)-1,COUNTA($B$14:$B$18)))+1,COLUMNS(B23:$B23),INT((R OWS(B$23:B23)-1)/IF(ROWS(B$23:B23)<=COUNTA($B$4:$B$8),COUNTA($B$4:$B$8),COUNTA($B$14: $B$18)+1)+1)),"")

[mahmoud-lee]

You did it
Thank you, Mister (Admin)
You are wonderful

[Ingolf]

Hi,

INDIA is missing in Table 3 (USA is 2 times)

[mahmoud-lee]

You're right
the row No. (28) Repeater
I think the right solution
Like this