Quickly fill blank cells with data above in Excel

How can I put a blank row in every same data in an easy way. For example I want to put a blank row after product 1 and product 2 so on.

thanks

can we do that with vba

❤

THANK YOUUU

Some time formate is different it is not working.
How to make as same format

Thanks a lot

THANK YOUUU SO MUCH! BLESSINGS TO YOU BRO!

Excellent thank you very much dude

Some videos are just treasures. Thank you so much!!! You can type whatever filler you need and then click Ctrl+Enter and then it will be in all blanks.

This was EXACTLY what i was looking for, AWESOME

Oh my lord thank you!

How to do this bottom to top can you show please

thanks a lot!

Great. Thanks!

THIS SAVE MY LIFE

How to do this In Mac , as you know Mac is shit, no special option in foto

it worked i love you with enteriety of my soul and body thankyou this has saved precious 3h of my life <3

Thank you!

GIVE THIS MAN A NOBEL PRIZE!!!!

Thank you

Unreal

Excellent tutorial

I am not getting the required results, it's just pasting in first level blank cell selected area, can any one please guide me

Could you please tell me how you grouped the data in the column ?

This is good for quickbooks

Saved my life.

I’m back because of how much I refer to this video. Best thing ever

Thanks a lot for this!

Thank you

Thanks ji

BROOOOO I HOPE YOU UNDERSTAND HOW IMPORTANT THIS TUTORIAL FOR ME BIG THANKSSS

Superb, and now how can do this in reverse like replace the same data with blanks just the first cell for each new data shall remain exavtly opposite to this method. How to achieve that?😅

awesome thank you

Look at you being a hero!! This is greatly appreciated, thank you so much

thanks you so much for that useful tutorial, It works but I don't fully get the logic behind it

Very usefull

Thank you for saving my time! Subscribed!

Sweet and simple instruction. Thank you!!!

Thank you very much

Saved me a lot of work and with a quick and simple explanation. Thank you.

Thanks a lot 😊

Thanks you 👍

I cannot thank you enough! You are a life saver

Thanks a lot bro very helpful pls continue to do this ❤

You're a hero lol

You earned a new follower! Amazing.