Inserting a second row if a cell has a value

		Microsoft Office Forums > Microsoft Excel > Excel
Inserting a second row if a cell has a value

FAQ

Thread Tools

Display Modes

12-19-2019, 02:43 AM

Joanne

Windows 7 32bit Inserting a second row if a cell has a value

Office 2010 32bit

Advanced Beginner

Join Date: Jul 2013

Posts: 58

Inserting a second row if a cell has a value

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,

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
syntax for inserting blank line before inserting table and after a line or paragraph	SamDsouza	Word VBA	8	08-04-2019 11:10 PM
Clear all cell colors within a range starting at cell A8 and change row of active cell to yellow	FUGMAN	Excel Programming	7	02-05-2017 08:37 AM
Inserting Cross References into Cell	mikemike616	Word VBA	4	08-19-2015 08:43 AM
Inserting Images into a Table Cell without Moving the Text	suzan	Word	0	06-27-2014 05:20 AM
Inserting a date calculated from a table cell	theMikeD	Word	2	09-11-2012 05:46 PM