Hi guys.

I know this has been answered and i'm still searching for that answer but am kind of in a hurry

I have a simple 1 column spreadsheet. Many cells have x2,x3,x4,etc indicating there are X number of those single items.

What I want to do is create duplicate rows and remove that xNumber.

I i guess take that number... -1 from the value and duplicate the row that many times. I say -1 from the value because the row that's there counts as 1.

If I have to manually remove the xNumbers via replace I can do that. Making the correct duplicate rows is what I need for now.


Example

Column
--------
Something
Everything x2
Somethingelse
Somethingcool x4
Somethingneat x2
Nothing

would be

Column
--------
Something
Everything
Everything
Somethingelse
Somethingcool
Somethingcool
Somethingcool
Somethingcool
Somethingneat
Somethingneat
Nothing


Thank you for your time.