Excel Insert Ingenious: Insert 2 Rows After Each Change in Customer - Episode 2158 

If you like this tip, please click Subscribe and click the bell icon for notifications.

Great trick : )

How can I insert a row after every 2 rows with one stroke? I have about 4k rows of data and 5 columns.

Nice one without using VBA.

Wonderful trick, thank you very much Bill, the formula is amazing!

Will this work if the 2 consecutive values in a column are different?

Does the formula work if I have only one ocurrence of a customer, let's say AT&T?

Life Saver. I had 14000 rows in a sheet. You are definitely a life saver. Thanks a lot.

Sir, How to insert 2 blank rows after each row having name of companies from cell A1 to A30

HI bill.... is there any plans to make videos on DAX and Adv DAX ??

Cool trick! Thanks!

Triple Magic!)

Hi Bill I have to insert rows after every 5th row... how can I insert.? And I want to insert numbers for every 5th row, like 5-10-15-20...... after 5 - 5 rows. Is it possible...?

Thanks a lot! This gives so many new ideas to us new learners

Fantastic tip!

Another great video. My 2 cents. I personally like Ctrl+ and Ctrl- (numeric keypad) as the fastest way to insert or delete rows. It seems logical to me. After you had selected the numeric values, I would have Ctrl+spacebar to select the entire row, then Ctrl+ to insert rows. Personal preference I guess. If you don't select the entire row then you have to answer the question in the dialog box.

this was useful, but I mean you can't insert two rows at once if a value doesn't repeating more than two times.

small time, simple formula, BIG HELP, THank you

Can this be accomplished with VBA?

Hello sir, How can I do sum only not hidden value in Excel.

how to insert rows without affecting data in other column?

Hi I am Indian ,how to buy that guy can u send link is easy for me

Awesome trick! Thanks Bill !

Slick! No VBA

Very smart trick

Spinny Excel

Educative tutorial.