Populate Column if blank

Question

Hi All, I hope you're all staying safe and well.

Essentially, I want it so that if column 1 is blank, it'll take the data from column 2. If the data in column 2 is blank, it'll take the data from column 3 and so forth. You can find the input and the desired output here:

Is there a way to do this without a lot of IF formulas? There's about 100 columns so it's way too much of a hassle to do it manually. I have attached a sample data set below.

Thank you!

Alteryx Example.xlsx

chuckleswk · Answer

You can use something like this to bring it all to a single column:

concat.yxmd

Chantelb · Answer

Hi @Andyhjtran

You could transpose the data, filter out the null values and then use the sample tool to take the first value for each row.

Hope this helps!

Cheers,

Chantel

Alteryx Example.yxzp