Populate table with respect to another table

[Exceltung]

Hi

Excel 2016 (Windows) 32 bit

	A​	B​	C​	D​	E​	F​
1​	Table 1​	​	​	​	​	​
2​	Place/Week​	1​	2​	3​	4​	5​
3​	A​	1​	2​	ZZ​	ZZ​	​
4​	B​	​	1​	4​	​	3​
5​	​	​	​	​	​	​
6​	Table 2​	​	​	​	​	​
7​	Place/Week​	1​	2​	Z​	4​	5​
8​	A​	1​	2​	ZZ​	ZZ​	​
9​	A​	1​	2​	ZZ​	ZZ​	​
10​	B​	​	1​	4​	​	3​
11​	B​	​	1​	4​	​	3​

Sheet: Sheet1

As shown above, I need to create Table 2 with data from Table 1.
The first column of Table 2 takes reference from the first column of Table 1.
What is the best method to create Table 2?
Thanks in advance.

 

[etaf]

try
=INDEX(C$4:C$6,MATCH($B9,$B$4:$B$6,0))

Book2
	A	B	C	D	E	F	G
1		B	C	D	E	F
2	A
3	1	Table 1
4	2	Place/Week	1	2	3	4	5
5	3	A	1	2	ZZ	ZZ
6	4	B		1	4		3
7	5
8	6	Table 2
9	7	Place/Week	1	2	3	4	5
10	8	A	1	2	ZZ	ZZ
11	9	A	1	2	ZZ	ZZ
12	10	B		1	4		3
13	11	B		1	4		3
14	Sheet: Sheet1
Sheet1

Cell Formulas
Range	Formula
C9:G13	C9	=INDEX(C$4:C$6,MATCH($B9,$B$4:$B$6,0))