Hi.

I am hoping this is easy but knowing my history with Excel, It's probably not :D

I have attached the examplefile and what I want is a formula in the Z Column that gives me the last cell in the same row's value.

So for example In Z2 I want the text from D2 to be shown since thats the last cell in that row with information (except the formula from the Z Column of course) and then the same for Z3-Z11.
The file I am building will have about 150 row's to do the same with but a formula in Z2 finding the latest cell with text in it from row 2 and paste it there in Z2.

I hope this makes sense.
I am ok with adding another sheet and run the formula in there, as long as it still works as an o365 file uploaded to a sharepoint.

examplefile.xlsx

Thank you in advance!