I have some data in column X and in Column Y (Cell Y2) i have written some text. I want the same text to be written till the last row upto where the data present in column X. Could somebody please help me on this. Attached the excel screenshot.
Note : The range is dynamic