Split out text into new rows

[fish221171]

Dear Excel Experts,

I have a spreadsheet with multiple rows and columns, some of the data in column F for example has the following in a single field separated out with comma;

Server A,Server B,
Test Server a,

I want to split this out with a VBA script or a formula and insert a new row below so it then appears like;

Server A
Server B
Test Server a

Can anyone help?

Thanks again

[Norie]

Do you want to copy what's in the rest of the row to each of the new rows?

[fish221171]

Do you want to copy what's in the rest of the row to each of the new rows?

Actually yes that would be useful, thank you.

[kvsrinivasamurthy]

This code splits data in F column. See file.

Please Login or Register  to view this content.

[FlameRetired]

A formula way. With the text string in A1 and this in A2 filled down.

Please Login or Register  to view this content.

If I have interpreted correctly.

[fish221171]

This code splits data in F column. See file.

Please Login or Register  to view this content.

This is excellent thanks very much, solved my problem.

[fish221171]

A formula way. With the text string in A1 and this in A2 filled down.

Please Login or Register  to view this content.

If I have interpreted correctly.

Thanks also for your input FlameRetired this is also very useful

[FlameRetired]

You're welcome. Thanks for the feedback.

[kvsrinivasamurthy]

Thanks for feed back.