Macro needed to ensure values A to K are evident in a dataset

[fdiddy]

Hi All,
Stuck on the below - i would appreciate if anyone could help.For each instance of the value in Col A in Table 2 ,Col B should have all the values as listed in Table 1.If any one of the values are missing then a row should be inserted and Col B & Col E populated with the missing values (example. H. Camera & I. Graphics Card in Table 3).A "No Value" should populate all the adjacent cells.

Hope I've made this clear enough for people to understand - thanks everyone

Table 1

A. CPU

B. RAM

C. Storage

D. Battery

E. Screen

F. WLAN Card

G. OS

H. Camera

I. Graphics Card

J. Keyboard

K. Palmrest / Fingerprint

Table 2

Country	SKU Type	SKU Num	SKU Ex. Name
Germany	A. CPU	12345-A	Intel 9th Gen Core i5-9400H
Germany	B. RAM	12345-B	8GB, 1x8GB
Germany	C. Storage	12345-C	256GB SSD
Germany	D. Battery	12345-E	68Whr
Germany	E. Screen	12345-F	15.6" FHD Anti-Glare Non-touch
Germany	F. WLAN Card	12345-G	Intel Dual Band Wireless AC 9560
Germany	G. OS	12345-J	No Media
Germany	J. Keyboard	12345-K	Internal German
Germany	K. Palmrest / Fingerprint	12345-L	Palmrest Thunder

Table 3

Country	SKU Type	SKU Num	SKU Ex. Name	Missing Record
Germany	A. CPU	12345-A	Intel 9th Gen Core i5-9400H
Germany	B. RAM	12345-B	8GB, 1x8GB
Germany	C. Storage	12345-C	256GB SSD
Germany	D. Battery	12345-E	68Whr
Germany	E. Screen	12345-F	15.6" FHD Anti-Glare Non-touch
Germany	F. WLAN Card	12345-G	Intel Dual Band Wireless AC 9560
Germany	G. OS	12345-J	No Media
No Value	H. Camera	No Value	No Value	H. Camera
No Value	I. Graphics Card	No Value	No Value	I. Graphics Card
Germany	J. Keyboard	12345-K	Internal German
Germany	K. Palmrest / Fingerprint	12345-L	Palmrest Thunder

 

[fdiddy]

Can Anyone shed some light on this?