Macro to convert multiple-line cells to indivual rows.

Try this:-
NB:- This code will alter your Data.

Please Login or Register  to view this content.

Regards Mick

I tried this and it deleted the multi rows but it only created one row after. I need a row for each different value in the multi row column. Just to clarify, for the columns in my example that have the 3 rows in one cell, each line has a different value. I would need to turn this one row into 3 rows.

This may be a better example

example2.PNG

Try this:-
Results sheet2

Please Login or Register  to view this content.

Regards Mick

This is great. Thank you!

Just to clarify, what does the number 3 represent in this code?

Please Login or Register  to view this content.

It is the offset columns from column "A",Offset 3 being column "D", I took that for the count of the Multiple lines in one cell.
If your data changes and column "D" is not Multiline, then this line will need changing to reflect that.
Although not covering all eventuallities , it was the easiest way when I was not sure how the data was laid out in all situations.