How to merge text based on a specific condition
I'm consolidating some questionnaires in Excel, in fact, over 50 questionnaires with more than 100 Lines with 3 individual questions in Each. The Numeric answer I can quantify, the problem is the text.
I can only think into consolidate all questionnaires by copying and pasting in the botton and then quantifying by using textjoin with IF. The real deal is that we probably gonna have to textjoin more than 50 texts based on the name of the question. Is there anyway to do this? The Logic is something like this:
=WHERE A:A="Question 1"; Then Textjoin("|";0;C:C)
I know Excel has no Where, but i found this the best way to explain
I Tried Used Textjoin, but I'd have to select cell by cell over 50 thousand lines
Solution
You can use FILTER to return "Question 1" rows only:
=TEXTJOIN("|",0,FILTER(tblData[Answer],tblData[Question]="Question 1"))
- Get all first level keys of rows in a 2d array where a column value is partially matched by a search term
- Determine if a value exists in a 2d array
- Count the number of objects in an array of object with a specified property value
- Sum the correlated values of two array columns
- Count rows of a 2d array which contain a qualifying column value
- Splitting a Map instance into two separate arrays
- php - find if an array contains an element
- Find the column value of the first item in a multidimensional array with a sought value in a deep subarray
- How to pass an array argument to the Bash script
- Get a column of values from the specified subarray of a multidimensional array
- Search a 2d array for a qualifying column value and return its first level key
- Filter a 2d array to keep rows which have a specified column value
- Start from second item in forEach loop
- Malformed C/C++ Multidimensional Array Initialization in GCC
- Determine if all values in a flat array are null
- Will these two methods of accessing the array implemented identically or not?
- Converting ArrayList of Integer objects to an int array
- jQuery .map into array
- Why are arrays still in C# when we are actually always using List<T>?
- Determine if any row in a 2d array has a qualifying column value
- Populate a 2d array from a flat array and another 2d array
- Filter out phrases in a flat array of comma-separated values which do not contain all search terms
- Merge PHP const arrays to new const array without nesting
- Filter a 2d array to only keep rows with two specified column values
- Filter out elements of a flat array which do not contain all search terms
- Filter a 2d array by a flat whitelist array
- Get the key of the last qualifying value in an array
- Determine if all values in all rows of a query result set are null
- Search a 2d array for a row containing a qualifying column value and return its parent key
- Determine if qualifying values exist in an array