CODEWITHSUNDEEP
google-sheetsconcatenationgoogle-sheets-formulatransposearray-formulas
Jon Lane
Jon Lane

Reputation: 1

Delimit and join in Google Sheets

I have a range of data in Google Sheets, column A is a list of unique identifiers (eg "ABCD1"), column B is a delimited list of attributes of each (A,B,C...) . I want to produce a list of unique identifiers and every single attribute across 2 columns (for example, ABCD1 A). Please help!

raw data

outcome

Upvotes: 0

Views: 62

Answers (1)

player0
player0

Reputation: 1

try:

=ARRAYFORMULA(SPLIT(A1&"♦"&TRANSPOSE(SPLIT(B1; ",")); "♦"))

0

Upvotes: 1

Related Questions