Merge lists with headings

Try this.

1. give each table a range name (let me know if you dont know how to do that)
I used List_1 and List_2 (range names dont like spaces, so I used underscore()

Then to do the extract...

	A	B	C	D	E	F
1	List 1			Merged
2	A	12			List 1	List 2
3	D	5		A	12
4	E	17		B		16
5	G	24		D	5	8
6	K	15		E	17
7	L	9		G	24
8	Q	2		K	15
9	V	20		L	9	10
10				P		36
11	List 2			Q	2
12	B	16		V	20	6
13	D	8
14	L	10
15	P	36
16	V	6

E3=IFERROR(VLOOKUP($D3,INDIRECT(SUBSTITUTE(E$2," ","_")),2,0),"")
copied down and across

Yes, you would need that lost 1st, but that could be easily created IF the list does not change. yes, correct, just copy 1 list then copy the 2nd below, and use Remove Duplicates

Hi theorize99,

What if you simply appended the second table to the bottom of the first table and then did a Pivot Table. You'd need to add a column, showing which list the data was from.
PT for theorize99.xlsx

Happy to help and thanks for the feedback