With almost universal availability of Internet and the availability of reliable on-line productivity tools, such as Google Docs, individuals as well as companies are switching over to Cloud Computing. In this blog I will post items of interest to my colleagues/patrons/clients.
Monday, December 18, 2017
yogi_Combine Row By Row Non-Blank Entries In Columns A to D With A Hyphen
Alright community, I'm conceding that I may have been out of the GSheets game for too long and have lost the edge!
I have a spreadsheetwhere some columns have numbers and alphanumeric sets, and some are blank. I'd like to concatenate down the whole column, adding a hyphen between each, but only if there is data in the cells. The function will be implemented on a Form Response sheet so I don't want to have to autofill down the column. I'd like to just have one function.
I can easily do this with =ARRAYFORMULA(A2:A&"-"&B2:B&"-"&C2:C&"-"&D2:D) but of course it will add unnecessary hyphens when there are blank cells in a row.
...Which pretty much yielded desired results except that it only formats based on the first row of data it sees so the rest of the column is only correct in the instances that the row's contents match the first row of data.
Anyway, I'm stumped and need some help. I saw this postbut I don't really understand the construction of the solution and therefore don't know if it will apply to my sheet.