Insert a row after "," in a cell

[Closed]
Report
-
Posts
2819
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 25, 2021
-
Hello,

I have a 2 columns such as below:

Name Rules
John T3456,T4567,T6799
Cersei T5643,T4532

I would like to have a macro that would do this:

Name Rules
John T3456
John T4567
John T6799
Cersei T5643
Cersei T4532

Does anyone help me please?

1 reply

Posts
2819
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 25, 2021
486
Hi Nolwën,

Use the text delimiter (or text to column found under the Data ribbon) on column B to make your data look like the poster below, so you can use the same solution.

https://ccm.net/forum/affich-823522-rows-and-columns#p823566

Let me know if any issues arise.

Best regards,
Trowa