Combining data and missing values

[suds144]

Hi, I'm trying to combine two columns of data.

Current Input

Ideal Output

I want to combine the two columns. So where "Games V2" is empty to input data from "Games". I tried using transpose and then formula tool but it came out weird (the data double). I tried using a formula but it isn't working i.e. IF Null ([GamesV2) etc.

Thank you :)

[mbarone]

Hi @suds144 , here's a great section of the Alteryx help files on Conditional Functions .  That should help you create your formula.

[atcodedog05]

Hi @suds144 

Can you share your formula and logic of the usecase maybe we can guide you to get on the right track.

Happy to help : )

[nitin_l · Accepted solution]

Will be able to guide if what error you are encountering. 

[suds144]

Hi, I This helps so much!

[suds144]

Hi,  I know where I went wrong! I didn't add "ELSE [Games V2]" to the formula.