Hello,
I've looked over all the compilations I could find and am unable to determine if a formula is possible for what I need to do in Excel or not. Basically I'm trying to find a way to create copies of a row X times where X is the value given (always a whole number) in another column on the same row of the original document. So in example:
Using the below column data:
A | B |
Amber | 4 |
Carol | 2 |
The desired output would turn into:
A | B |
Amber | 4 |
Amber | 4 |
Amber | 4 |
Amber | 4 |
Carol | 2 |
Carol | 2 |
The name existing a certain amount of times on separate rows is the important value. It doesn't matter what happens to the number in the second column so long as the name now exists on separate rows where count of rows is equal to the number given on the original document.
I appreciate any help or even confirmation that a formula for this would not work.
Bookmarks