Sure, give me some time. Thanks

The person who has hide the 6 digit that can make it possible to know the rest 6 digit Thanks for comments.

You want this in Excel or VBA?

Thanks for support

You are welcome

You're welcome

Please suggest if this video helps

Thanks for commenting here, please if this video helps

Thanks for commenting here, please if this video helps

Thanks for commenting here, please if this video helps

Thanks for commenting here, please if this video helps

Thanks for commenting here, please if this video helps

Thanks for commenting here, please if this video helps

Hi please suggest if this video helps.

You are welcome!

Thanks for support

Sure, give me sometime, i will sent it to you, maybe tomorrow. thanks for commenting

yes, it is possible, i think this video i have created for this purpose only. Please review the thoroughly and suggest if this is not fit for you. Thanks for your feedback

Thanks for support

When you apply filters, go to the top and see the oldest to new and and newest to old, thanks

Thanks for your support.

Thanks for putting your comments here, sorry for late response. Go to home tab and then View tab here you can see the split button. If you want to split data vertically then select row and click on Split your data will be spit vertically or if you want to split data vertically select any column and press split button. thanks

Please specify your question clearly

Thanks for your support.

Thank you so much for your kind words! It means a lot to know my content is making a difference for you.

Thanks for putting your query here, great question, In that case will use the same method as we are doing the last row find, that case will will find the last column. Thanks

You're most welcome

Will upload soon

Glad it helped

sorry for late response, go to View tab and then select Project Explore. thanks

@@excelnsg1588 tq sir ... I already do it

Yes may be, but not tried. 576 is a huge nos. to get data from, may be there is any other option or resource but do you have really such requirement. thanks for putting your thoughts

Welcome

Welcome

Hello, thank you for putting comments here, for removing apostrophe from multiple columns, first enter 1 in any separate cell and then copy it by pressing CTRL+C, then select the whole dataset and go to Paste Special Option and select "Multiply" radio button, means you have to multiple whole dataset by 1, and press OK, your all apostrophe will be removed. Thank you.

@@excelnsg1588 Thanks for the reply. Apart from multiplicatiin is there any other simple way ?Cant we use convert Text to columns methid here also ?

@@Allwell11 Yes you can. also you can add 0 in the entire dataset by paste special method but using text to column is also a good way to do so. thanks

@@excelnsg1588 Its not working

Working on it. thanks

Please use the below link for Website post VBA Macro to Filter Excel Data and Create Separate Sheets Based on Unique Values excelnsg.com/2024/07/15/vba-macro-to-filter-excel-data/

one sheet has 1048576 rows and around more that 16 thousands column, if your data is more that this then we have power query to merge. I know how to use power query in big data, please let me know if this requires you. But first try to do this VBA method to solve your query. thanks for comments

please specify your question clearly, i will try to do that.

Enjoy

Thank you, so much for your beautiful comment

Yes, but folder create karne ke liye useful haie. Thanks for comment.

means, who Sonu?

Defining a range, you need to add (" ") Quotation mark

@@excelnsg1588 asking for _

Thanks

All values in one cell?

Please specify here or you can mail me at [email protected] Thanks

You're welcome

Thanks you like it.

Thanks for valuable comment