Vyacheslav SVX Company
Reputation: 51
Join arrays using function to create all combinations
I have one array:
Aaa
Bbb
Another array:
Ddd
Fff
How do I use one function to join the 2 arrays?
AaaDdd
AaaFff
BbbDdd
BbbFff
Upvotes: 2
Views: 46
Answers (1)
player0
Reputation: 1
=ARRAYFORMULA(SORT(
TRANSPOSE(SPLIT(REPT(CONCATENATE(A1:A&CHAR(9)); COUNTA(B1:B)); CHAR(9)))&
TRANSPOSE(SPLIT(CONCATENATE(REPT(B1:B&CHAR(9); COUNTA(A1:A))); CHAR(9)))))
Upvotes: 1
Related Questions
- Formula to Concatenate All Combinations of Values Two Columns Without VBA
- Google Sheets row to array
- Concatenate columns while avoiding blanks and duplicates
- google spreadsheet: join arrays using function NOT CODE
- Google Sheets Text Join to consolidate rows into columns
- Combine column cell interchangeably in one column
- Mix data of multiple columns into one column
- Delimit and join in Google Sheets
- Generate a list of combined columns
- [google spreadsheets]Joining Multiply Arrays in one formula