Видео

Thank you for sharing this 💌

This has changed my life.

Thank you for nice video. I am doing exactly the same as you are describing but getting error in "Row()-1" where the bracket of row is getting red in my excel 365. Is there any changes should I do ? thank you !

Thanks, this was really helpful!

Hi, I did the same but slicer not impacting the below formula table values. Its remain same, What mistake I Did?

Eat something before recording and speak clearly, loudly giving space between sentances. Thank You.

Ashish, thank you for saving my day! Good tutorial!

Thank you so much for such a detailed explaination!

Hello Ashish I went through your video Can u plz suggest from where can I get the data sheet to practice

Thanks for this simple and succinct video

Thank you so much 🙏🏽

You are a genius, thank you greatly for your help, you have solved my issues. After scouring Google for a while, this is the absolute best method for doing just this task. Microsoft really need to add in a way for us to do this easily, hopefully that comes soon enoough. To add, you've also shown me (perhaps without realising); that if my data set is static, e.g. for a one-time graph, I can copy/paste my pivot table and create a pivot chart from that pasted value data. That has allowed me to utilise Grand-totals within the graph. If the dynamism is required, the rest of the video helps solve that issue. Excellent video and thank you for helping me out.

Thank you! Thank you!! A thousand times thank you!!! You have no idea the amount of time this saved me (don't worry i didn't try the hard way. I had a feeling something like this existed). Again thank you!!!

Hi sir, can you please tell how to account for cancelled sales in revenue for orders placed in previous accounting period?

Can we use this on two different tables? Like name &no. And name & no. ,i have to align using no.

Hi Ashish, please share excel file, in the download link file is not available Thank you

You might have just helped get me a promotion, good job

Thank you, this video really helped me out.

Thanks in a million. Great stuff. I have used it. Grade: A++💥

Sir I didn't get all values but some values like N/A what mistake I did in it

Exactly what I was looking for. Thanks man!

What if I had 100 payments going across columns, you would need to create 100 different tables? Is there a better way if you have many more columns of information?

cool stuff

I don't really get the Power Query. A lot easier for me just to use MS Access.

Do you have an update video with the new version of Excel please??

Thanks sir very helpful video

Thanks sir very helpful video

I am running with an issue, I have two work sheets and I created tables for both separately but when I go to query wizard there it shows table of second sheet only. Can you please suggest why this is happening?

Thank you boss!!

I want to say thanks sir it a great

You need to focus on your English, your pronunciation is worst...

One question, what to do if total columns in worksheets are different ???? Right now it's not working with this method please suggest

This is excellent I was searching something like this for more than a month, then landed here... Please post more videos like this which would be helpful on day to day basis in excel.

Thanks a ton! It works.

If the Data sheets combined exceed the >1M+ row limit in Excel, will this still work?

error could not add table pls help

thanks for the video but why tf is it so complicated to do that simple task microsoft should get their shit together

Exactly what I was looking for! Thank You!

Hi Ashish I m facing problem at the end where it says could not add the table 'dummy', please suggest.

Almost 5 years later, happy to say this still works. Great explanation. Thank you!

dont know how but Thanks, this is what I was looking to find. have a great day!

It was excellent sir. I was looking for same solution since 2 months..

In this case, googlesheet is better

I have been looking far too long for this solution

this is like an alternative to using power pivot for appending data, nice!

You can hear it coming at 7:53 haha

Thank you for posting, very helpful. Quick question: could this technique be used to combine several pivot tables?

Can you tell me how to put pivot using share point

Sir i am getting total of count and total of Sum when i merge two workbooks. Pls help

YOU SAVED US, THANK YOU SOOOOO MUCH