How to expand excel values with a quantity

**daveywavey** · 03-29-2011, 08:49 PM

Hi I have got 2 columns. Column A has got Identities in it, and column B has got a quantity, I want to expand this so that it results in a column with just the identities in it repeated as many times as the quantity.

Example:See pic

Want to get the resultant column

Any help would me much appreciated

**MarvinP** · 03-29-2011, 10:48 PM

Hi Dave and welcome to the forum,

find the attached with this macro that will do what you ask. The code looks like this.

Please Login or Register  to view this content.

**daveywavey** · 03-30-2011, 09:44 PM

Thanks HEAPS for your help works like a charm

How to expand excel values with a quantity

LinkBack

Thread Tools

Rate This Thread

Display

How to expand excel values with a quantity

Re: How to expand excel values with a quantity

Re: How to expand excel values with a quantity

Thread Information

Users Browsing this Thread

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions