# Google Sheets formula - multiply all combination of all cells into Column6

• Status: Closed
• Prize: \$10
• Winner: zskl

## Contest Brief

I need to get results in Column6 from multiplication of cells Column2 and Column4

Input data:
Column1 | Column2 | Column3 | Column4
car | 1 | used | 1
vehicle | 2 | old | 4
auto | 2 | bazar | 2

Column5 - I already know the formula, its &quot;=ArrayFormula(transpose(split(rept(concatenate(A3:A5000&amp;char(9)),counta(C3:C5000)),char(9)))&amp;&quot; &quot;&amp;transpose(split(concatenate(rept(C3:C5000&amp;char(9),counta(A3:A5000))),char(9))) )&quot;

Column6 - for each combination i need multiplication Column2*Column4 (eg. 2*4=8)

Result data:
Column5 | Column6
car used | 1
vehicle used | 2
auto used | 2
car old | 4
vehicle old | 8
auto old | 8
car bazar | 2
vehicle bazar | 4
auto bazar | 4

Take in account Column1 and Column3 could expand into unlumited cells. So the input is not always 3x3 cells.

I would like to remind, that result should be in Google Sheet, not in Microsoft Excel. Unfornunataly, this is condition.

Winner

## Employer Feedback

“Thanks, simple fast solution”

michalemem, Czech Republic.

## Public Clarification Board

• Contest Holder
• 1 month ago

Also, take in account Column1 and Column3 could expand into unlumited cells. So the input is not always 3x3 cells.

• 1 month ago
• Contest Holder
• 1 month ago

I would like to remind, that result should be in Google Sheet, not in Microsoft Excel. Unfornunataly, this is condition.

• 1 month ago

## How to get started with contests

• Post Your Contest Quick and easy

• Get Tons of Entries From around the world