09 - Combine Excel Tables in the Same Workbooks Using Power Query (Append Method)

In this video, I will show you how you can append multiple Excel tables into one table using Power Query Append functionality

This method is best for those situations when you have the data in the same format and you want to combine these tables.

#Excel #PowerQuery #ExcelTips

[sintulaha]

Sumit Sir thanks to you for this free video to understand power query with so ease and simple language.

[forestsunrise]

Thank you so much! Your channel is one of the best Excel tutorial channels on Youtube. Your videos have saved my life so many times!

[mohdzulfarhanbinibrahim]

I love that this video exist to help my work becoming easier. Thank you!

[emilysilk]

This is just what I was looking for. Thank you!

[tkc]

Thank you Sir. Your step by step video guide was very informative and well paced.

[coffeeaddit]

Exactly what I was looking for! Great explanation too! Thank you so much!! ;)))

[reazulkabir]

Thank yiu so much man. It was really helpful for me. Recently, I have used it for my office workwork and that was great.

[notanaive]

I love your demonstrations. They are detailed and that's great. I have a question. What to do if we add a new worksheet to the existing ones?

[jdray]

Exactly what I was looking for, thank you. Is there a way to name the Region by formula, using some reference like source.TableName (which is a made-up thing)?

[dorinpopa]

Great videos you have made. Very good style of teaching ! One question : why isn't the appended data showing the commision in percentage as you have selected for the column type?

[otroleonarbe]

Good explanation. Personally, I think it's easier to go to Advanced Editor in Power Query and copy the script and paste it to the other sheets and just change the Name of the region.

[FazlinHaddad-tmiv]

Hi There, thanks for explanation. Could you explain to me how to do complex reconciliation of transaction?

[infaziqbal]

Hi Sumit! Thanks for all the great videos you have posted. They are very helpful. I have a question relating to this video: Is it not possible to create a query once for East and then just copy the steps and apply it for the other tabs ie West, North & South?

[kripamittal]

Great video Sumit .I had a doubt while appending queries even though we change the commission format to % it still shows as decimal format.What can be done about it.

[dhivyaethirajan]

Hello sir thank you for your knowledge transfer pls let me know how to combine all excels together using Power query when the columns are not same in excels

[AbhishekGuptaDoha]

Hello Sir,


Excellent tutorial.
However, I have a problem at hand.
I would like to use power query to read files and folder data on a daily basis and append to the table till yesterday.
So I want this to add these as transactions on a daily basis.

So on day 1, I will use get data from files and get all the fields like date, path, extension, etc.
However on day 2 and forward, I wish to append new data from files and folder to my existing table.

Please help solving this issue.

[udaymhaskar]

Hello Sir, Thanks for this vdo.
however, when I clicked on file -> Close to load tab I m getting 'only create connection' option disable. M I mssing here something? Please help. Thanks in advance.

[nitinkolhe]

Sumit
Thank you very much. I wonder if you can advice me. I have applied many queries to one work-sheet (say, 19-20). I did not use folder and imported the worksheet in the power query. Now, I need another similar worksheet from another year (20-21) and I wish to combine them. However, I wish that all queries applied to first sheet also needs to be applied for the second sheet. I will be grateful for your advice please

[Entertainmenthuba]

Hi summit,
In order to update when original data changes, is it necessary to have the original changed date in same sheet ? E.g. I have appended June data of four regions and now i have the July data, do i need to copy the July data in the same sheet containing the appended data ? or we have to replace the June data with the july data in the same worksheet ?

[Freemarkets]

Is there a way to add a column to each of the data tables in power query based on the table name?