column C
=rept(a2,b2)

a2 = 123456
b2 = 12


hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Igneshwara reddy" escreveu:

Hi,

I need a help with the formula. I have data like this.

Column A Column B Column C Comun D
G5370-0101-6090
123456 12
253689 25

In column C the results should be as Column A 123456 should repeat 12 times
as in column B and in column D the description G5370-0101-6090 should repeat
12 times in Column D.

Please help me out with the formula.

Regards,
Igneshwara reddy.