Level I

assigning an orientation rooms

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?

Article Labels

    There are no labels assigned to this post.