Ctrl+s
09-23-2012, 01:53 AM
Greetings,
Can any one help on this below situation.
I have data in two Columns one Columns contains data with different line in each cell
like
MR X
MR Y
MR Z
and in the other column with single line like
Success
Failed
Please see the below image for clear view.
http://i49.tinypic.com/9rt9mu.jpg
In this case, I want to split the data in to each line in to each row.
Like MR X Failed
Mr Y Failed
Mr Z Failed and so on..
Can anybody has an Idea to solve my problem with a Macro?
Thank you in Advance.
Best Regards,
Can any one help on this below situation.
I have data in two Columns one Columns contains data with different line in each cell
like
MR X
MR Y
MR Z
and in the other column with single line like
Success
Failed
Please see the below image for clear view.
http://i49.tinypic.com/9rt9mu.jpg
In this case, I want to split the data in to each line in to each row.
Like MR X Failed
Mr Y Failed
Mr Z Failed and so on..
Can anybody has an Idea to solve my problem with a Macro?
Thank you in Advance.
Best Regards,