Counts Expanding

[sathishkm]

Hi All,

I have company names in column A and there counts in column B. I need to expand the companies according to the count mentions in columns B. Please find the attachment.

[jindon]

Try

Please Login or Register  to view this content.

[Bo_Ry]

Please try

Please Login or Register  to view this content.

[kvsrinivasamurthy]

If you are interested in FORMULA solution.
ARRAY formula in F2 then copied down till blank cells are seen.

Please Login or Register  to view this content.

To enter ARRAY formula
Copy and paste the formula in cell
Press F2
Press Ctrl+Shift+Enter together
Excel covers the formula with {}.

[sathishkm]

Thanks. I got what I was expecting it