Inserting a second row if a cell has a value

[Joanne]

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,

[ArviLaanemets]

Have a separate ClientProducts sheet with according table. And a report sheet, which reads data from Clients and ClientProducts tables.