Split Cell containing multiple soft breaks

Hello

Because of historical reasons we have an important excel sheet that has cells containing multiple lines and a cell next to it also with soft breaks containing data that refers to the previous cell. We need to split the soft breaks into different lines.

It is hard to describe the issue, but it will be most clear with giving an example:

This is what it looks like at the moment:

Name Cust 1

Startdate Cust 1

Product A Product B Product C

Key A Key B Key C

This is what is should look like afterwards:

Name Cust 1	Startdate Cust 1	Product A	Key A
Name Cust 1	Startdate Cust 1	Product B	Key B
Name Cust 1	Startdate Cust 1	Product C	Key C

As we have about 1000 lines in our sheet I would love to see this automated. Could somebody help me with this?

Thanks in advance!

Tim

Would dumping the content/result in a different worksheet be acceptable?

Easier than inserting rows in between the original data

If unpacking into a different worksheet is acceptable, the following code should work

Please Login or Register  to view this content.

Bernaar, please remeber to click the star icon ("Add Reputation") if you are happy with my contribution