The event manager at Oakstage needs a roster that can support scheduling and equipment collection. The contact file mixes names and locations in single fields, stores an email address when only the organization domain is needed, and records units alongside each person's allowance. A second file spreads availability across day columns.
These tasks combine the column tools you have already used. Read the required output names carefully. A derived value must come from the row's data, not from a number copied out of the preview. Pay attention to equal boundaries, zero units and missing availability. Replacing a role label should not alter a longer label that contains the same word. For availability, a missing day is unknown while zero is a recorded amount. Keep that distinction when reshaping the table.