I was searching for exactly this same issue for so long time and your video came as like a gift to me. God bless you

Superb! Bravo👏👏👏

You are my savior sir, subscribed now! and big Like! Thank you from Colombia my friend!

Thank u So much 😁😁

I spent a day looking for this thank you!

Thank you. U saved hours of my time 🙏🏽

I was thinking a lot about how do I do this, but you made so much easier, thank you God bless you

Super & more useful this formula for me

It helped me with one of the most crucial data sorting tasks! Thank you so much!

This is so helpful!!! ILYSM!!!!

Very useful and saved lot of time

You just saved my 2+ hrs work.

You have just sorted out my problem...thank you very much

excellent. Just it solved my problem. Thanks

good thought

Too good @ 5.41 solved a query dot on - Thank you so much !!

Thank you so much!!! Helped me solve a problem that I just encountered. Very useful and informative. Please share more tricks.

Thank you for helping with the short cuts

simple but yet powerful

Very useful trick 👌

Absolutely useful. Just helped solve a problem I was working on

@praveenk9158

3 жыл бұрын

Thank u bro ...... Very use full to me ... Thanks a lot

Wonderful… thanks 🙏

Really helpful .. thank you

very useful, thank you for sharing

Thanks alot. Really appreciated :)

THANK YOU SO MUCH!

Thanks, Its good one

Thank you

Thank you!!!

Thanks

Thank you sir you save my day

@Excelrush

3 жыл бұрын

Do subscribe to the channel!

Superb 👌🏻

Thanks sir

Thank u so much

Good Sir

how to do this if I have data in 5 merged cells? I have data in a merged cell (merged up and across), I want to paste this data into the cells below by merging them in a similar way. How to do that?

kya mast kam karta hai re tu maksud bhai

@Excelrush

3 жыл бұрын

Hahaha thank you!

Sir, how to insert blank rows before/above specific text ? please reply.

@samarthhosamani16

Жыл бұрын

yes, same doubt

Can we not do for all columns in one go ?

my god ilove you,

What if I need to take value from side

Can you plz explain if data is more than 1 lakh then wht to do.

How to do this using a formula?

ok, but how to do the same in horizontal line?

If i want to fill the series in each empty cell continue with the number just above it... How to do it.?.. If i have 2 in uper cell.. Thn I have to fill 2,4,5,6,7,8... Then with next cell in same column have 3 in upper cell..n want to fill next numbers below it ...have huge data... Please guide

@Excelrush

3 жыл бұрын

Just type group 1 and group 2.. then select both cells.. and drag it down using the bottom right part.. it will happen

@sagarijadhav7281

3 жыл бұрын

@@Excelrush m doing it... But its huge data.. Its takes so much of days to drag it manually...is there is any option like this video to fill it quickly

@Excelrush

3 жыл бұрын

Use the Fill option in the HOME tab

@Excelrush

3 жыл бұрын

Home - fill - series

@sagarijadhav7281

3 жыл бұрын

@@Excelrush u r not getting my point.. Its not to one Series through out the table... For instance in this video.. In cell of group 1..i have to fill next blank columns with group 2,group 3.. So on.. There are some numbers in one columns with some blank cells below it.. Have to fill next numbers in all that blank cells with above cell value..so can not use fill option..

No cells were found are showing

It is not working, it is copying the cell address to blank cells

@samarthhosamani16

Жыл бұрын

yes, same for me, while doing horizontal line.

Thanks alot. Really appreciated :)

Very Very useful, thanks a lot!!!!

@Excelrush

3 жыл бұрын

Do subscribe to the channel!