Home > Enterprise >  Generate possible combinations into separate columns in Google Sheets
Generate possible combinations into separate columns in Google Sheets

Time:12-25

I found many solutions online, but they are generating combinations as combined text. I want to generate them into separate columns like on picture below.

Formula should be in C1, based on columns A and B. New rows in A and B will populate new rows (combinations) in C and D.

enter image description here

  • Related