JOIN results of VLOOKUP into one string in Google Sheets
I have following task for my Google spreadsheet: JOIN strings in all cells that are to the right of certain id.
- To phrase it differently:
SELECT A, JOIN(',', B) GROUP BY A, WHERE A = myid;if JOIN was an aggregation function. - Or in other words:
=JOIN(',', VLOOKUP(A:B, myid, 0))if VLOOKUP could return all occurences, not just first one. - One picture better than of 1000 words:
Is this possible with Google Spreadsheets?
Solution
I believe you could use the FILTER function instead of VLOOKUP to filter a range based on an ID and then JOIN the returned range.
The documentation for FILTER is here: https://support.google.com/docs/answer/3093197
For example:
- You put
=UNIQUE($A:$A)in D2 to get all the IDs. - Then in E2 you put
=IF($D2="", "", JOIN(",", FILTER($B:$B, $A:$A=$D2)))and then copy it down.
- Java regex for URL
- Perl last capture match variable
- Issue while masking Credit Card No. before and/or after spaces
- Extracting a numeric value from the middle of a String field in MS Access 2016
- Datadog Regex is not replacing the right data
- How to parse pdf in r and then correctly convert or extract spaced/tabbed pieces of text into columns of dataframe?
- Does there exists a PowerShell Escape function for Special Characters
- regex for semver
- How to use PHP to echo entire word with occurance of character sequence?
- How to extract or capture the value from stdout_lines of an Ansible playbook?
- PCRE Regex to SED
- Parsing formulas efficiently using regex and Polars
- Regex - check if input still has chances to become matching
- Commenting Regular Expressions
- Add space after specified data using regular expression in Visual Studio
- Regular Expression to collect everything after the last /
- python regex to get text within a pattern defined
- Python regex for Java annotations
- How to limit/cap values exceeding a certain value in Notepad++
- Replace variables in a formula with their definitions
- How do I fix this Reg ex so that it matches hyphenated words where the final segment ends in a consonant other than the letter m
- How to match strings having optional group and not containing specific group?
- Using Regex to get multiple data on single line by scraping stocks from yahoo
- Javascript regular expression password validation having special characters
- php extract only selected rows from external table
- A regexp to retrieve either og:url meta or link rel="canonical"
- Extract all matching font-family attributes from string
- Using callable_iterator (re.finditer) causes Python to freeze
- Replace Spaces with New Lines in Comma-Separated Number Lines
- R split 1 column into several columns based on regex value