1

You can get that with a custom function, but it would probably make more sense to use a plain vanilla spreadsheet formula. The example results you show is row-by-row concatenation rather than a Cartesian product of two sets. To get row-by-row concatenation with a spreadsheet formula, ignoring blank values, use this: =arrayformula( flatten( filter(A2:A, len(...


1

When you have two onEdit(e) functions in the same script project, only one of them will run. The simplest pattern to combine two onEdit(e) functions is to rename the existing functions to doFirstThing_(e) and doSecondThing_(e), and then call them like this: function onEdit(e) { doFirstThing_(e); doSecondThing_(e); } You should however consider ...


1

Nowadays is common to find websites that where optimized for performance, security, etc. That looks to be the case of blockchaing.com as there is not a "link" directly attached to the referred "button". You could use the Chrome DevTools to analyze how the button works but you should learn about modern web development. In this specific ...


Only top voted, non community-wiki answers of a minimum length are eligible