VBA or Formula that combines two lists and outputs them in a particular format

[kabutocat]

Hi all, I have two tables and it's hard to describe using words what I would like so I'll describe it using tables.

Table 1

Code	Description
A01	Liaison with Client
A02	Desktop Analysis
A03	Plan Output

Table 2

Phases

Preliminary

Detailed

Delivery

And I'd like a code that would produce something like this:

Code	Description	Phase
A01	Liaison with Client
		Preliminary
		Detailed
		Delivery
A02	Desktop Analysis
		Preliminary
		Detailed
		Delivery
A03	Plan Output
		Preliminary
		Detailed
		Delivery

Thank you for your help!

 

[Legacy 143009]

With the setup below:
D4 =IF(MOD(ROW(A1),COUNTA($A$9:$A$11)+1)=1,INDEX($A$4:$A$6,MATCH(0,COUNTA($D$3:D3,$A$4:$A$6),0)),"")
E4 =IFERROR(VLOOKUP(D4,$A$4:$B$6,2,0),"")
F4 =IF(MOD(ROW(A1)-1,COUNTA($A$9:$A$11)+1)>0,INDEX($A$9:$A$11,MOD(ROW(A1)-1,COUNTA($A$9:$A$11)+1)),"")