In the context of transforming data in SQL, especially when dealing with data analysis tasks, one often needs to reshape data from a long format (where each row represents an observation) to a wide format (where each row represents an entity and columns represent different attributes of that entity). Which SQL keyword can be used to achieve this transformation?