Combining text data
The raw data being analyzed may not always be in the correct form for analysis, and in some cases, may need to be combined so it can be correctly processed. For example, first and last name data is often collected in separate columns and combined during data preparation.
In this exercise, you've been tasked with creating the final credit for each film, which must have the form: FILM TITLE by Director Name.
Questo esercizio fa parte del corso
Data Analysis in Google Sheets
Istruzioni dell'esercizio
- In
G2:G11, create the final credit for each film and director.
Esercizio pratico interattivo
Passa dalla teoria alla pratica con uno dei nostri esercizi interattivi
Inizia esercizio