Make new column with last populated column of a series of columns using power query excel

[BZimber]

In power query for excel I can get as far as columns A-E. What I would like to achieve within power query (maybe power pivot?) is to have a new column added 'F' which is the data of the last populated column from A-E.
Sample Data attached

 

[alansidman]

Look at this: https://community.fabric.microsoft....Column-Name-with-populated-values/m-p/3834452