Insert 3 rows based on cell value

[DeanMcK]

Hi,

I need to insert rows based on cell value.

Currently a cell can have Test1, Test2, Test3. I need to insert 3 rows and add Test1, Test2 and Test3 into the new rows and copy the the remaining row values.

I have

Current data

Current.PNG

Wanted outcome

WantOutcome.PNG


Any help is appreciated

Cheers

Dean

[nankw83]

Hi Dean,

How about this

Please Login or Register  to view this content.

[DeanMcK]

Thanks nankw83,

With a little massaging of the data and your code works a treat.

Thanks heaps.

Dean

[nankw83]

Glad to help & thanks for the reps