The array expands with one formula

Question

input:

A 4
B 3
C 2

output:

A
A
A
A
B
B
B
C
C

Use only one formula. no code please.

+1

jason Jul 27 '13 at 11:36

1 answer

Adaml · Accepted Answer · 2013-07-27T21:46:05+0000

=ArrayFormula(IFERROR(TRANSPOSE(SPLIT(CONCATENATE(REPT(A:A&CHAR(9);B:B));CHAR(9)))))