Power Query Formula Inserting Custom text

Hello everyone,

While using power query, I am looking for a formula that will insert text into the rows below its column, I can't figure out how the formula should be and I am working with two worksheets, one is for Project A and the other is for Project B.

I want the formula to check if there is any text on the next rows and display a custom text.

Can you help ?

Much obliged !