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
Bookmarks