Can i sort on company when information is on 2 rows?

Access to new Room in S2.xls

First of all, i was unsure to what forum to post this is. My apologies if it is in the wrong one.

We are moving to a new room in a large office building, and the offices/corridors are restricted with ID cards and pin codes. We have over 1000 users, from many different companies, and only a few are granted access to this new office site. there are 2-3 companies only that will be granted access, and if we could somehow sort by company it would save us a lot of time telling security who they can give area access to or not. This function would also benefit us in the future, now we basically write a list of names and they have to manually go through the list.

The attached file is edited with made up names etc, but it is how the program exports the user list to excel.

So, is there a way i can sort by company, or hide the ones that don't meet my criterias? Or any other suggestions or guides would be great.

thanks in advance.

This puts the information in an easier layout.

Access to new Room in S2_2.xls

but I cannot beleive that a 1000+ company doesn't have IT guys that could have solved this


-edit... one remark..
copy - paste the sheet2 values to another sheet...

Thank yo so much! You're a superstar!
IT would not help without a ticket, which again would take god-knows-how-many-days, and they don't like to play around in excel etc...