Search for text and sort data

[vij]

Hi All,

I have data as per the file attached and have to separate the data as per facility desc (3 facilities) as per the table given below. The file is attached as per the url below.

https://www.dropbox.com/s/t5bwjnkq0pd0yx0/sample.xlsb

<tbody>
</tbody>

Result expected in this format
Facility_Desc
Noida Tech Blvd (Sec 127), INDIA (NOI BLVD-PP)

Input Desc	Alarm_Desc	Alarm_Desc	Alarm_Desc	Alarm_Desc
	Alarm Door..	Door Forced Open - Perimeter..	Door Held Open - Perimeter..	Door Held Open..
821-1-19 NOI BLVD:SERVICE LIFT FL6 DO	0	0	0	0
802-1-01 NOI CC:FLOOR1 TURN3 IN	0	0	0	0
802-4-00 NOI CC:SHIPPING REAR DOOR	0	0	0	0
821-1-25 NOI BLVD:SERVICE LIFT FL7 DO	0	0	0	0
804-3-01 BAN:FLOOR 2 UPS ROOM	0	0	0	0

<tbody>
</tbody>

Thanks in advance for the help,
Vij