Keep order of door number to match with room number

I am trying to export a multicategory schedule related to rooms to excel.

Accordingly, I got all the room data and trying to add door names as well. But the door number of each room is going wrong place and don’t know how to obtain door number at the right place (matching rooms).Capture

Any help would be greatly appreaicated! Thank you

This would get you Doors in each room: