Macro to split data into multiple cells

[mark888]

Hi All,

I need some help on a macro.
I have multiple entries in column C which I would like to split it up and show in multiple cells based on Column A& Column B. For example as below

Original
Column A Column B Column C
A 13.05.07 1,2,4,5
B 15.08.09 9,8,7,6


Output
Column A Column B Column C
A 13.05.07 1
A 13.05.07 2
A 13.05.07 4
A 13.05.07 5

Any idea anyone able to help me on this? Have attached the sample in tab Sample and how it should be in tab Output.
Hope someone is able to help me out. :-)

Kind Regards,
Mark.

[alansidman]

Try this:

Please Login or Register  to view this content.

[millz]

Try:

Please Login or Register  to view this content.

[mark888]

Try this:

Please Login or Register  to view this content.

Hi Alan,

This works althought there seems to be some mismatch. For example the first record shows 40 in tab Sample but 43 in tab Output.
Manually i calculated it should show only 40 records.

Kind Regards,
MArk.

[mark888]

Hi Alan,

This works althought there seems to be some mismatch. For example the first record shows 40 in tab Sample but 43 in tab Output.
Manually i calculated it should show only 40 records.

Kind Regards,
MArk.

Hi Alan,
Sorry i know what went wrong. It calculated the first 3 which I already had there in the first place. :-)

Kind Regards,
Mark.

[mark888]

Hi Alan,

This works althought there seems to be some mismatch. For example the first record shows 40 in tab Sample but 43 in tab Output.
Manually i calculated it should show only 40 records.

Kind Regards,
MArk.

Hi Alan,
Sorry i know what went wrong. It calculated the first 3 which I already had there in the first place. :-)

Kind Regards,
Mark.

[mark888]

Try:

Please Login or Register  to view this content.

Hello Millz,

This works perfectly as well. Many thanks sir.

Kind Regards,
MArk.

[ikboy]

try this:

Please Login or Register  to view this content.

[mark888]

try this:

Please Login or Register  to view this content.

Hi Ikboy,

This works perfectly as well. Many thanks all. :-)

Kind Regards,
Mark.