Is there a formulaic way to turn a list in two columns like this:
<tbody>
</tbody>
into a new list in a single column like this (where the number of times that a name appears is dynamic based on the number next to it in the original data like above):
Albert
Albert
Albert
Bob
Bob
Charles
Charles
Charles
Charles
I feel like I need an incrementing variable and am not sure how to accomplish that in Excel or if it's even possible. Thanks for any assistance you can provide.
Albert | 3 |
Bob | 2 |
Charles | 4 |
<tbody>
</tbody>
into a new list in a single column like this (where the number of times that a name appears is dynamic based on the number next to it in the original data like above):
Albert
Albert
Albert
Bob
Bob
Charles
Charles
Charles
Charles
I feel like I need an incrementing variable and am not sure how to accomplish that in Excel or if it's even possible. Thanks for any assistance you can provide.