Subscribe Bookmark RSS Feed

assigning an orientation rooms

cgomez

Community Trekker

Joined:

Sep 25, 2012

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?