Populate Column if blank

[Andyhjtran]

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!

[Chantelb]

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

[chukleswk]

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