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
Last Comment
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
thx
You're welcome.
-Glenn
-Glenn
Microsoft Excel
Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.
144K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
ASKER