finnstone
asked on
concatenate columns
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.
pehub-2019-03-07--1-.csv
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.
pehub-2019-03-07--1-.csv
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thx
You're welcome.
-Glenn
-Glenn
ASKER