How to combine dynamic columns in Google Sheets while retaining data in other rows?

I have a Google Form that asks people to fill out their name, gender, and then their size preference for shirts and pants. The form automatically outputs the 2 sizes in separate columns.

enter image description here

I want to combine the size columns while retaining the name and gender of the respondents, like this:

enter image description here

I know I can use arrays and queries to do this:

={query({A16:D18},"select Col1, Col2, 'Shirts', Col3 where Col1 is not null");   query({A16:D18},"select Col1, Col2, 'Pants', Col4 where Col1 is not null")} 

Which gets me exactly what I want. But I’m trying to make it dynamic in case I need to add more questions in my form about sizes (which increases the # of columns).

Right now if more columns are added, I would have to add another query() line manually and make it look like this:

={query({A16:D18},"select Col1, Col2, 'Shirts', Col3 where Col1 is not null");   query({A16:D18},"select Col1, Col2, 'Pants', Col4 where Col1 is not null");   query({A16:D18},"select Col1, Col2, 'Dresses', Col5 where Col1 is not null")} 

Is there any way to dynamically add another query() line if I tell it to look for 3 columns now?

I know this seems like weird request if I’m willing to enter in “3” manually – but I want other people in my company to be able to use this spreadsheet and asking them to manually change the # of columns is easier an less error-prone than having them modify the formula.

I know how to dynamically change the Col#, just not the extra query line…

How to combine Mac terminal find -name patterns?

I use Xcode. I want to use bash to batch modify the UI fonts.

Here is the code to “.xib” and “.storyboard”:

xibd(){      cd "$  (dirname "$  1")/.." && pwd      find . -type f -name "*.xib"  -exec  sed -i '' s/'\<fontDescription key=\"fontDescription\" type=\"system\" pointSize=\"17\"\/\>'/'\<fontDescription key=\"fontDescription\" name=\"PingFangSC-Regular\" family=\"PingFang SC\" pointSize=\"12\"\/\>'/ {} +       find . -type f -name "*.storyboard"  -exec  sed -i '' s/'\<fontDescription key=\"fontDescription\" type=\"system\" pointSize=\"17\"\/\>'/'\<fontDescription key=\"fontDescription\" name=\"PingFangSC-Regular\" family=\"PingFang SC\" pointSize=\"12\"\/\>'/ {} +  } 

I want to combine -name “.storyboard” and -name “.xib”, how to achieve it?

I tried

find . -type f -name '*.storyboard'  -o  -name  "*.xib"  -exec  sed -i '' s/'\<fontDescription key=\"fontDescription\" type=\"system\" pointSize=\"17\"\/\>'/'\<fontDescription key=\"fontDescription\" name=\"PingFangSC-Regular\" family=\"PingFang SC\" pointSize=\"12\"\/\>'/ {} +   find . -type f -name "*.xib|storyboard"  -exec  sed -i '' s/'\<fontDescription key=\"fontDescription\" type=\"system\" pointSize=\"17\"\/\>'/'\<fontDescription key=\"fontDescription\" name=\"PingFangSC-Regular\" family=\"PingFang SC\" pointSize=\"12\"\/\>'/ {} + 

it does not work.

I have read the related of man find. Still working on it.

Macro to combine selected workseets using checkboxes

I’m still very new to VBA and I was wondering if what I’m trying to do is even possible.

I have several worksheets in the same workbook and I’m trying to select the worksheets by using check boxes, each of which corresponds to a particular worksheet, and then clicking a button to combine the selected worksheets into one new worksheet. All the worksheets have the same structure (same number of columns, headers, etc).

The worksheets are: IT Certification, Business Skills & Productivity, Database and Cybersecurity

and in this case I’m trying to store them in variables depending upon whether the check box that refers to them has been clicked:

Here is the code I have so far:

`Private Sub CommandButton1_Click()

Dim ITCert As Worksheet Dim BSProd As Worksheet Dim DC As Worksheet

If Me.CheckBox1 = True Then ITCert = ThisWorkbook.Sheets(“IT Certification”) End If

If Me.CheckBox2 = True Then BSProd = ThisWorkbook.Sheets(“Business Skills & Productivity”) End If If Me.CheckBox3 = True Then DC = ThisWorkbook.Sheets(“Database and Cybersecurity”) End If

End Sub`


I’m not quite certain how to combine these sheets. Do I need to create a loop (I’m thinking no because a user would already select the sheets in question by clicking the check boxes). I want thinking of somehow adding the variables I’ve assigned the worksheets to together, but I’ve been unable to make this work.

Any help/suggestions would be very much appreciated!

Combine hook_search_execute

I have hook for user_search_execute and node_search_execute for both user and nodes but i want to merge both into mymoduel_search_execute but only node_search_execute uses index not user_search_execute like below :-

     /* node search execute */      function node_search_execute($  keys = NULL, $  conditions = NULL) {         // Build matching conditions         $  query = db_select('search_index', 'i', array('target' => 'slave'))->extend('SearchQuery')->extend('PagerDefault');         $  query->join('node', 'n', 'n.nid = i.sid');         $  query             ->condition('n.status', 1)             ->addTag('node_access')             ->searchExpression($  keys, 'node');          // Insert special keywords.         $  query->setOption('type', 'n.type');         $  query->setOption('language', 'n.language');         if ($  query->setOption('term', 'ti.tid')) {             $  query->join('taxonomy_index', 'ti', 'n.nid = ti.nid');         }         // Only continue if the first pass query matches.         if (!$  query->executeFirstPass()) {             return array();         }          // Add the ranking expressions.         _node_rankings($  query);          // Load results.         $  find = $  query             ->limit(10)             ->execute();         $  results = array();         foreach ($  find as $  item) {             // Render the node.             $  node = node_load($  item->sid);             $  build = node_view($  node, 'search_result');             unset($  build['#theme']);             $  node->rendered = drupal_render($  build);              // Fetch comments for snippet.             $  node->rendered .= ' ' . module_invoke('comment', 'node_update_index', $  node);              $  extra = module_invoke_all('node_search_result', $  node);              $  uri = entity_uri('node', $  node);             $  results[] = array(                 'link' => url($  uri['path'], array_merge($  uri['options'], array('absolute' => TRUE))),                 'type' => check_plain(node_type_get_name($  node)),                 'title' => $  node->title,                 'user' => theme('username', array('account' => $  node)),                 'date' => $  node->changed,                 'node' => $  node,                 'extra' => $  extra,                 'score' => $  item->calculated_score,                 'snippet' => search_excerpt($  keys, $  node->rendered),                 'language' => entity_language('node', $  node),             );         }         return $  results;     } 

i want to combine both queries into one even search url anything else.

please help..

Can you combine War Caster, whip, and Warlock Features to Eldritch Blast enemies with reach?

So, Whip is a one-handed martial weapon with reach. Reach is a feature that, among other things, lets you make opportunity attacks with that weapon out to 10 feet instead of just five.

Equipment

Reach (p. 147). This property also determines your reach for opportunity attacks with a reach weapon.

— PHB Errata

War Caster lets you cast a spell instead of making an opportunity attack.

Both Hexblade and the Eldritch Invocation Improved Pact Weapon have ways of letting you use a one-handed martial weapon as your spellcasting focus.

So, if you have War Caster, and you have a whip that you can use as a spellcasting focus, would that let you use Eldritch Blast on anyone who provokes an opportunity attack within 10 feet?

As far as I can tell, the real question is whether “spell using the weapon as a spellcasting focus” counts for the “with that weapon” requirement of the Reach property, but I haven’t been able to find a clear answer on that.

What is the best way to combine two tables into a new report based on multiple criteria?

I have two reports from a database (Report A, Report B). I need to combine these reports into one report (Report C) in excel where the rows align based on The columns “Machine” and “Start Time”. Report A and Report B will have new content added every day. What is the best method to create and maintain Report C?

Report A Report A

Report B Report B

How to combine two QUERY results into one column

I have a following QUERY

=query(XX!A2:A;" select A where A>'50' ") 

and

=query(YY!A2:A;" select A where A>'50' ") 

how do I combine these two data sources so I don’t have to have two separate columns they process data to?

  • best would be if 1st row from XX is followed by 1st row of YY, 2nd row followed by 2nd row….and so on
  • If above option is not easily possible, it is OK for one query to be followed by the second one (if I expect correctly that the start of the second will be moved with newly added data into the first one)

Thank you for any help

Can we combine a reflection and a resemblance principle in a class theory?

The following theory is a class theory that combines two principles that of reflection and resemblance, informally it says that the class $ V$ of all sets resembles a set $ W$ that stands as a sub-world in the sense that every $ \in, \subseteq $ bounded sentence from the $ V$ world would have an $ W$ copy of it fulfilled in the $ W$ world as long as its fulfilled in the $ V$ world and vise verse! yet $ W$ supports a reflection principle on it reflecting all pure set theoretic properties inside it.

The question is: Is this consistent?

Reflection Resemblance class theory $ “RR”$ , is a theory formulated in mono-sorted first order predicate logic with primitive symbols of $ “=, \in, W”$ , standing for “identity, membership, and Sub-world”, where the last is a constant symbol.

Axioms are those of identity axioms +

Extensionaltiy: $ \forall x (x \in a \leftrightarrow x \in b) \to a=b$

Define: $ set(x) \iff \exists y (x \in y)$

Class Comprehension: if $ \varphi(y)$ is a formula in which $ x$ is not free, then: $ [\exists x \forall y (y \in x \leftrightarrow set(y) \wedge \varphi(y))]$ is an axiom.

Let $ V$ be the class of all sets.

Subworld: $ W \in V$

Reflection: if $ \varphi$ is a formula in $ L(=,\in)$ , in which $ x$ occurs free, with parameters $ \vec{p}$ , then: $ $ \vec{p} \in W \to [\exists x \in V (\varphi) \to \exists x \in W (\varphi)]$ $ is an axiom.

Resemblance: if $ \varphi^X$ is a formula in prenex normal form, whose matrix is in $ L(=,\in)$ , and every variable in its prefix is either bounded $ \in X$ or $ \subseteq X$ , then: $ $ \varphi^V \leftrightarrow \varphi^W $ $ , is an axiom.

Size limitation: $ \forall x (x \in V \leftrightarrow |x|<|V|)$

Foundation over all classes.