Create duplicate rows for a single colum with 'x2' or 'x3' are in cells.

[justchil]

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.

[watersev]

hi justchil, welcome to Excelforum, option to make it

[bheanloh]

Try

Please Login or Register  to view this content.

Assuming data starts at A1

[justchil]

Thanks!

Trying it in a few... my Office installation was really messed up... had to remove it manually and am now finishing the fresh install.