Good morning

I have a large spreadsheet showing Name, Address, Tel Number. The following cells show serial numbers. Currently, if there are two products, the serial numbers are shown in adjacent cells.

Now, if a client has two or more products, I need to show these on separate rows.

I'm looking at having to do this manually, but wondered if there was a quicker way.

I would be grateful for any help.

Regards,