Combining data and missing values

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

Dummy data.xlsx

Datasets

Input

Output

Transformation

Accepted answers

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

Combining two columns.yxmd

All comments

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

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

Happy to help : )

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

Combining two columns.yxmd

Hi, I This helps so much!

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

Quick Links

Tags

This months top contributors

atcodedog05 19458

Qiu 15867

MarqueeCrew 13708

apathetichell 13703