Revision history [back]

The method to generate a new column by using values from several columns that correspond to a specific string is as follows:

1. Identify the string that you want to use as a filter for your data.

2. Create a new column in your dataset where you want to store the values that correspond to the string.

3. Use the conditional IF statement to check if the string exists in each column that contains the data you want to extract.

4. If the string exists, extract the relevant data and enter it into the new column.

5. Repeat this process for each column that contains the data you want to extract, making sure to add the extracted data to the new column.

6. Once all the data has been extracted, review the new column to ensure that the values are correct.

7. Save the changes to your dataset.