Find text string after the ", " then move its down to the last row

[tuongtu3]

Hello All,
Is it posible to find the text string after ", " then move all of them down to the last row:

Data
CellA2 = Line01, line08, line09-10
CellA3 = Line05
CellA4 = Line15, Line25


Outcome
CellG2 = Line01
CellG3 = Line05
CellG4 = Line08
CellG5 = Line09-10
CellG6 = Line15
CellG7 = Line25

Regards,
tt3

[millz]

Yes it's possible and will show you in another hour or so after I reach my office (and if no one else already did).

[Trebor76]

Hi tuongtu3,

Please Login or Register  to view this content.

HTH

Robert

[jindon]

Try

Please Login or Register  to view this content.

[tuongtu3]

@Trebor76: Your code work but can you make it sort in order.

Please Login or Register  to view this content.

@jindon: Your code work, sort it in order but can you make it continues to the last row.

Thank you very much for you time and help.
Regards,
tt3

[jindon]

What do you mean?

It should go through to the end of Col.A.

Or post your workbook.

[tuongtu3]

Hi Jindon,
Please take a look at below:

1st Data
CellA2 = Line01, line08, line09-10
CellA3 = Line05
CellA4 = Line15, Line25


1st Outcome
CellG2 = Line01
CellG3 = Line05
CellG4 = Line08
CellG5 = Line09-10
CellG6 = Line15
CellG7 = Line25

User enter another data

2st Data
CellA2 = Line03, line07
CellA3 = Line04
CellA4 = Line14, Line25

2st Outcome
CellG2 = Line01
CellG3 = Line03
CellG4 = Line04
CellG5 = Line05
CellG6 = Line07
CellG7 = Line08
CellG8 = Line09-10
CellG9 = Line14
CellG10 = Line15
CellG11 = Line25

Regards,
tt3

[jindon]

Change to

Please Login or Register  to view this content.

[tuongtu3]

@Trebor76
@Jindon

Thank you very much for your time and help.

Regards,
tt3