How to merge a column data into a specific column

[jnorth]

Hello Experts,

I want the values of this "Blank" column to show within "Marketing". How can I do this?

This data is coming in from Salesforce. Both "Marketing" and "Sales" is referenced under my "Lead_Source_Type" field. But I also get these leads under a "Blank" column. Since getting this fixed in Salesforce is most likely not an option, how can I create a function that takes these leads under the "Blank" column and merge as a "Marketing" Lead_source_Type.  

I want the values of this "Blank" column to show within "Marketing"

[v-piga-msft]

Hi  @jnorth,

If I understand your requirement correctly that you want to have a new column that combine the values both the blank column and Marketing column.

You could go to Query Edtior and add a Custom column.

If you need additional help please share your expected output.

Best regards,

Cherry