Insert a row after "," in a cell

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