Output data form two tables to a combined third table

[jbarrick007]

I have two tables and want to show the combined results in a third table for a different reason. What is the easiest way to do this?
I dont want to simply combine them because they are divided by approval rating, and the third column is set just to show how many times there names are listed.

So the assignments table should show the combined results of the host and co host tables?


Thank you.

Host Schedule - Copy.xlsx
	A	B	C	D	E	F	G	H	I	J	K
1	Host and Co-host Schedule								Month Starting:	1/1/2021
2
3	Zoom Meetings
4
5
6	January
7	Mid-Week				Weekend				Assignments		Approved Host
8		Host	Co-Host			Host	Co-Host	0	Ted Walters		Ted Walters
9	1				1			0	Jeff Barrick		Jeff Barrick
10	2				2			0	Jonathan Smith		Jonathan Smith
11	3				3			0	Matt David		Matt David
12	4				4			0	Gary Page
13	5				5			0	Paul Greene
14								0	Owen Rivers
15	February							0	Reggie Schooley
16	Mid-Week				Weekend			0
17		Host	Co-Host			Host	Co-Host	0			Approved Co-Host
18	1				1			0			Gary Page
19	2				2			0			Paul Greene
20	3				3			0			Owen Rivers
21	4				4			0			Reggie Schooley
22	5				5			0
23								0
24	March
25	Mid-Week				Weekend
26		Host	Co-Host			Host	Co-Host
27	1				1
28	2				2
29	3				3
30	4				4
31	5				5
32
Sheet1

Cell Formulas
Range	Formula
A6	A6	=J1
A15	A15	=J1+31
H8:H23	H8	=COUNTIF($B$10:$C$19,I8)
A24	A24	=J1+62

 

[sandy666]

try Power Query with Append feature or Merge feature. You need to check which feature to use because your example doesn't show which table you want to connect to and how

 

[jbarrick007]

I have two tables and want to show the combined results in a third table for a different reason. What is the easiest way to do this?
I dont want to simply combine them because they are divided by approval rating, and the third column is set just to show how many times there names are listed.

So the assignments table should show the combined results of the host and co host tables?


Thank you.

Host Schedule - Copy.xlsx
	A	B	C	D	E	F	G	H	I	J	K
1	Host and Co-host Schedule								Month Starting:	1/1/2021
2
3	Zoom Meetings
4
5
6	January
7	Mid-Week				Weekend				Assignments		Approved Host
8		Host	Co-Host			Host	Co-Host	0	Ted Walters		Ted Walters
9	1				1			0	Jeff Barrick		Jeff Barrick
10	2				2			0	Jonathan Smith		Jonathan Smith
11	3				3			0	Matt David		Matt David
12	4				4			0	Gary Page
13	5				5			0	Paul Greene
14								0	Owen Rivers
15	February							0	Reggie Schooley
16	Mid-Week				Weekend			0
17		Host	Co-Host			Host	Co-Host	0			Approved Co-Host
18	1				1			0			Gary Page
19	2				2			0			Paul Greene
20	3				3			0			Owen Rivers
21	4				4			0			Reggie Schooley
22	5				5			0
23								0
24	March
25	Mid-Week				Weekend
26		Host	Co-Host			Host	Co-Host
27	1				1
28	2				2
29	3				3
30	4				4
31	5				5
32
Sheet1

Cell Formulas
Range	Formula
A6	A6	=J1
A15	A15	=J1+31
H8:H23	H8	=COUNTIF($B$10:$C$19,I8)
A24	A24	=J1+62

I am trying to combing the host and cohost list to the assignment table.

 

[sandy666]

where is the source tables (names) and which table is the result table
there are three tables January, February and March with host and co-host, so ?

maybe post example of source tables (with generic data) and expected result table based on source tables