Combining Competitor Data from Three Columns into Two Final Columns

Nicole B. · 2025-07-22T14:44:05.776Z

I have 3 columns: Competitor 1, Competitor 2, and Competitor 3. Some of these are empty. I would like 2 final columns: Competitor 1 and Competitor 2. How can I check across all 3 of these columns to get a final result for values in 2 columns.

Combining Competitor Data from Three Columns into Two Final Columns | Clay

5 comments

· Sorted by Oldest

Clay
APP
·
·
You can use the Merge Columns feature to consolidate your competitor data: 1. Click Add Column > Merge columns 2. Write a formula using "/" to reference your columns 3. Create logic to pull the first non-empty value across your three columns Alternatively, use the Formula feature: 1. Add a new column and select Formula 2. In the AI Formula Generator, describe what you want (e.g., "combine Competitor 1, 2, and 3 columns, prioritizing non-empty values") 3. Use "/" to reference each column 4. Generate and save the formula This will create your two final columns by intelligently pulling values from your three source columns.
Sources: Hide, Re-order, Sort, Filter, Merge Columns Table columns | Documentation | Clay University Formulas
Nicole B.
·
·
How do I make the output in the AI formula to 2 separate columns?
Clay
APP
·
·
To output AI formula results to 2 separate columns, you need to define column outputs: 1. In your AI formula setup, look for the "Add and define outputs" section 2. Create Fields - enter the field names where you want each output to appear 3. In your prompt, specify which information goes to which output field (e.g., "Output competitor 1 to the 'Competitor_1' field; output competitor 2 to the 'Competitor_2' field") 4. Use the dropdown to select the appropriate data type for each output field This will create two separate columns from your single AI formula instead of combining everything into one column.
Sources: Claygent: AI Web Scraper [Clay 101] - Clay University Use AI | Documentation | Clay University Use AI | Documentation | Clay University
Nicole B.
·
·
Where is the: Add and define outputs section
Clay
APP
·
·
The "Add and define outputs" section appears in step 6 when setting up a Use AI column: 1. Click Add column and select Use AI 2. Select your use case (choose "Content creation, manipulation" for your scenario) 3. Select a model 4. Write your prompt 5. Provide context (optional) 6. Add and define outputs - this is where you'll see the Fields section In the Fields area, enter the field names where you want each output to appear, then use the dropdown to select the appropriate data type for each output field.
Sources: Use AI | Documentation | Clay University Use AI | Documentation | Clay University

Clay
APP
·
·
You can use the Merge Columns feature to consolidate your competitor data: 1. Click Add Column > Merge columns 2. Write a formula using "/" to reference your columns 3. Create logic to pull the first non-empty value across your three columns Alternatively, use the Formula feature: 1. Add a new column and select Formula 2. In the AI Formula Generator, describe what you want (e.g., "combine Competitor 1, 2, and 3 columns, prioritizing non-empty values") 3. Use "/" to reference each column 4. Generate and save the formula This will create your two final columns by intelligently pulling values from your three source columns.
Sources: Hide, Re-order, Sort, Filter, Merge Columns Table columns | Documentation | Clay University Formulas
Nicole B.
·
·
How do I make the output in the AI formula to 2 separate columns?
Clay
APP
·
·
To output AI formula results to 2 separate columns, you need to define column outputs: 1. In your AI formula setup, look for the "Add and define outputs" section 2. Create Fields - enter the field names where you want each output to appear 3. In your prompt, specify which information goes to which output field (e.g., "Output competitor 1 to the 'Competitor_1' field; output competitor 2 to the 'Competitor_2' field") 4. Use the dropdown to select the appropriate data type for each output field This will create two separate columns from your single AI formula instead of combining everything into one column.
Sources: Claygent: AI Web Scraper [Clay 101] - Clay University Use AI | Documentation | Clay University Use AI | Documentation | Clay University
Nicole B.
·
·
Where is the: Add and define outputs section
Clay
APP
·
·
The "Add and define outputs" section appears in step 6 when setting up a Use AI column: 1. Click Add column and select Use AI 2. Select your use case (choose "Content creation, manipulation" for your scenario) 3. Select a model 4. Write your prompt 5. Provide context (optional) 6. Add and define outputs - this is where you'll see the Fields section In the Fields area, enter the field names where you want each output to appear, then use the dropdown to select the appropriate data type for each output field.
Sources: Use AI | Documentation | Clay University Use AI | Documentation | Clay University