Matching Data from two Sources, with INDEX/MATCH and/or Lookups

[Vic_c_Aug_2019]

I have two sources of data from two providers. Since they are similar, I would like to combine the two sources through formulas in-lieu of manually entering and adjusting the data. Can the Microsoft Community Help please provide different examples on how to approach this? Index, Match, Lookups, Aggregrate, etc.

Thank you all!

See attached Spreadsheet on what I want to achieve. 

[#2]

@Vic_c_Aug_2019 

In G5:

="EWP"&LEFT(MID(F5,FIND("-",F5),100),LEN(MID(F5,FIND("-",F5),100))-1)

Fill down.