I am working on a master sheet for safety across our company. I have multiple rows (each specific to a particular project), of which there is a column for subcontractors who violate safety protocol (linked to a project-specific SS). Is there a particular way or formula that can be used to take all of the text from each cell in a column, and list them in a single cell? The goal here is to incorporate this information into a Sight, which will be sent out company-wide at the end of the week. Any help would be appreciated!
