Insert a row after "," in a cell

Closed
Nolwën - Jun 30, 2015 at 03:08 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Jul 2, 2015 at 10:54 AM
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 response

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
Jul 2, 2015 at 10:54 AM
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
0