Hello there, help required

Am currently in my first day in analytics and I'm struggling to get the data to be compared to make it in a chart form. Say that I'm trying to compare my company's value to the industry's value.


Entire industry
Industry - Values
A - 246
B - 135
C - 123
D - 678
E - 250
...
Z - 789

My company
[B]Industry - Values
A - 250
C - 185
E - 200
...
Y - 520

The funniest part, is that 'My Company' do not have all the fields (say, 'B' and 'D' in the table), hence I'm unable to easily sort it and paste it next to the 'Industry' table, and I'm currently not sure which function/formula should I use, so that the column next to 'My Company' will be able to capture the ONLY necessary information from 'Industry' table, to be generated into a comparison chart. As the rows are almost 60+, it's almost impossible to make the table manually.

To make it easily, my outcome would be this;

Industry - Company comparison

Industry - Company
Industry - Company
A - 246 - 250
C - 123 - 185
E - 250 - 200
...

Help?