In a data table, I have a column of rooms (301, 401,...) listed for each hour of the year. Each day they will repeat. I would like to assign each room an orientation (S, W,..) in another column. There are 8760 rows. How might I assign the rooms to an orientation and have a column produced for all the rows?