Search table and transfer data

[jwhackle]

I'm new to the VBA world so I am unsure of even where to start with this one. What I have is a table with names and how far along those people are in there training in different areas. What I want to do is search that table for everyone who is training/basic in a certain area and copy their names down to another table which will populate data based on that name from a separate sheet. My first thought was to do some sort of Vlookup or index match loop to search the table but I can't seem to figure it out.

This is an example what the first table looks like where the data will be pulled from...
[TABLE="width: 500"]
<tbody>[TR]
[TD]Name[/TD]
[TD]Writing[/TD]
[TD]Math[/TD]
[TD]History[/TD]
[TD]Science[/TD]
[/TR]
[TR]
[TD]Joe[/TD]
[TD]Training[/TD]
[TD][/TD]
[TD]Proficient[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Steve[/TD]
[TD][/TD]
[TD]Proficient[/TD]
[TD]Proficient[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Mary[/TD]
[TD]Proficient[/TD]
[TD][/TD]
[TD][/TD]
[TD]Training[/TD]
[/TR]
[TR]
[TD]Sara[/TD]
[TD][/TD]
[TD][/TD]
[TD]Basic[/TD]
[TD]Proficient[/TD]
[/TR]
</tbody>[/TABLE]

This is what I want the other table to look like...
[TABLE="width: 500"]
<tbody>[TR]
[TD]Name[/TD]
[TD]Area[/TD]
[TD]Current Level[/TD]
[TD]Next Level[/TD]
[TD]Completion Date[/TD]
[TD]Comments[/TD]
[/TR]
[TR]
[TD]Joe[/TD]
[TD]Writing[/TD]
[TD]Training[/TD]
[TD]Basic[/TD]
[TD]Feb-19[/TD]
[TD]xyz[/TD]
[/TR]
[TR]
[TD]Mary[/TD]
[TD]Science[/TD]
[TD]Training[/TD]
[TD]Basic[/TD]
[TD]Aug-20[/TD]
[TD]qrs[/TD]
[/TR]
[TR]
[TD]Sara[/TD]
[TD]History[/TD]
[TD]Basic[/TD]
[TD]Proficient[/TD]
[TD]Dec-18[/TD]
[TD]abc[/TD]
[/TR]
</tbody>[/TABLE]

Any help on this would be greatly appreciated!!

 

[SpillerBD]

Your first table needs to be "Unpivoted", which is simplified through "Get and Transform"
Then you want to do VLOOKUP from another table, which would be best done with a connection in the Data Model.
The Data model holds your queries, data connections and data manipulations and feeds a Table and/or a Pivot Table.

However, Get and Transform is only included in Excel 2016. Data Model can be found in 2013 but the Un-pivoting is the trick then.