i need to automate the concatenation of columns
please see attached. anywhere there is text in col A , that is not a URL, i need to create a new value that is concatenating the columns to the right. note, there is not a fixed number of columns to the right.
then, i need all rows below rows with text to be deleted (not ones below urls rows). so delete row 5 but not row 7.