CODE EXAMPLE FOR PYTHON

Python Pandas: Create new column out of other columns where value is not null

df['AZ'] = df.loc[:,'A':'Z'].fillna(method='ffill',axis=1)['Z']