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.
[TABLE="width: 798"]
<tbody>[TR]
[TD] https://www.dropbox.com/s/t5bwjnkq0pd0yx0/sample.xlsb
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[/TR]
</tbody>[/TABLE]
Result expected in this format
Facility_Desc
Noida Tech Blvd (Sec 127), INDIA (NOI BLVD-PP)
[TABLE="width: 613"]
<tbody>[TR]
[TD]Input Desc
[/TD]
[TD]Alarm_Desc
[/TD]
[TD]Alarm_Desc
[/TD]
[TD]Alarm_Desc
[/TD]
[TD]Alarm_Desc
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Alarm Door..
[/TD]
[TD]Door Forced Open - Perimeter..
[/TD]
[TD]Door Held Open - Perimeter..
[/TD]
[TD]Door Held Open..
[/TD]
[/TR]
[TR]
[TD]821-1-19 NOI BLVD:SERVICE LIFT FL6 DO
[/TD]
[TD]0
[/TD]
[TD]0
[/TD]
[TD]0
[/TD]
[TD]0
[/TD]
[/TR]
[TR]
[TD]802-1-01 NOI CC:FLOOR1 TURN3 IN
[/TD]
[TD]0
[/TD]
[TD]0
[/TD]
[TD]0
[/TD]
[TD]0
[/TD]
[/TR]
[TR]
[TD]802-4-00 NOI CC:SHIPPING REAR DOOR
[/TD]
[TD]0
[/TD]
[TD]0
[/TD]
[TD]0
[/TD]
[TD]0
[/TD]
[/TR]
[TR]
[TD]821-1-25 NOI BLVD:SERVICE LIFT FL7 DO
[/TD]
[TD]0
[/TD]
[TD]0
[/TD]
[TD]0
[/TD]
[TD]0
[/TD]
[/TR]
[TR]
[TD]804-3-01 BAN:FLOOR 2 UPS ROOM
[/TD]
[TD]0
[/TD]
[TD]0
[/TD]
[TD]0
[/TD]
[TD]0
[/TD]
[/TR]
</tbody>[/TABLE]
Thanks in advance for the help,
Vij
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.
[TABLE="width: 798"]
<tbody>[TR]
[TD] https://www.dropbox.com/s/t5bwjnkq0pd0yx0/sample.xlsb
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[/TR]
</tbody>[/TABLE]
Result expected in this format
Facility_Desc
Noida Tech Blvd (Sec 127), INDIA (NOI BLVD-PP)
[TABLE="width: 613"]
<tbody>[TR]
[TD]Input Desc
[/TD]
[TD]Alarm_Desc
[/TD]
[TD]Alarm_Desc
[/TD]
[TD]Alarm_Desc
[/TD]
[TD]Alarm_Desc
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Alarm Door..
[/TD]
[TD]Door Forced Open - Perimeter..
[/TD]
[TD]Door Held Open - Perimeter..
[/TD]
[TD]Door Held Open..
[/TD]
[/TR]
[TR]
[TD]821-1-19 NOI BLVD:SERVICE LIFT FL6 DO
[/TD]
[TD]0
[/TD]
[TD]0
[/TD]
[TD]0
[/TD]
[TD]0
[/TD]
[/TR]
[TR]
[TD]802-1-01 NOI CC:FLOOR1 TURN3 IN
[/TD]
[TD]0
[/TD]
[TD]0
[/TD]
[TD]0
[/TD]
[TD]0
[/TD]
[/TR]
[TR]
[TD]802-4-00 NOI CC:SHIPPING REAR DOOR
[/TD]
[TD]0
[/TD]
[TD]0
[/TD]
[TD]0
[/TD]
[TD]0
[/TD]
[/TR]
[TR]
[TD]821-1-25 NOI BLVD:SERVICE LIFT FL7 DO
[/TD]
[TD]0
[/TD]
[TD]0
[/TD]
[TD]0
[/TD]
[TD]0
[/TD]
[/TR]
[TR]
[TD]804-3-01 BAN:FLOOR 2 UPS ROOM
[/TD]
[TD]0
[/TD]
[TD]0
[/TD]
[TD]0
[/TD]
[TD]0
[/TD]
[/TR]
</tbody>[/TABLE]
Thanks in advance for the help,
Vij