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

Рет қаралды 61,818

Күн бұрын

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.
✅ Power Query Course Download files: bit.ly/power-query-download
☕ If you find my Excel videos useful and would like to support me, you can buy me a coffee - www.buymeacoffee.com/SumitB
Free Excel Course (Basic to Advanced) - trumpexcel.com/learn-excel/
Best Excel Books: trumpexcel.com/best-excel-books/
Subscribe to get awesome Excel Tips every week: kzfaq.info...
#Excel #PowerQuery #ExcelTips

Пікірлер: 39

@sintulaha8659 4 жыл бұрын

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

@forestsunrise26 4 жыл бұрын

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

@mohdzulfarhanbinibrahim3510 Жыл бұрын

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

@notanaive 3 жыл бұрын

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?

@reazulkabir6534 5 ай бұрын

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

@tkc4612 4 жыл бұрын

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

@emilysilk3459 4 жыл бұрын

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

@coffeeaddi8t 2 жыл бұрын

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

@infinger2006 Жыл бұрын

Nice work - thank you

@dorinpopa6479 Жыл бұрын

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?

@devoosvideo2871 3 ай бұрын

its really helpful .. thanks dear

@trumpexcel 3 ай бұрын

Glad you found the video helpful 🙂

@otroleonarbe 5 ай бұрын

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.

@AlexanderJacobJames 3 жыл бұрын

Great explanation. Thank you.

@trumpexcel 3 жыл бұрын

Thanks for commenting Alex... Glad you found the video useful!

@jdray 2 жыл бұрын

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)?

@Kehkshah 2 жыл бұрын

Great .... thank you so much

@Exceltrick4u 3 жыл бұрын

I need this information. Thanks a lot

@infaziqbal44 Жыл бұрын

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?

@kripamittal2554 2 жыл бұрын

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.

@margad-erdeneboldbaatar4704 2 жыл бұрын

Thanks so much.

@dataanalyst839 Жыл бұрын

Hats of thanks

@FRANKWHITE1996 4 жыл бұрын

Thanks!

@FazlinHaddad-tm2iv Жыл бұрын

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

@study4734 2 жыл бұрын

Thanks

@dhivyaethirajan254 2 жыл бұрын

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 4 жыл бұрын

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.

@nitinkolhe1 3 жыл бұрын

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 3 жыл бұрын

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 ?

@user-rf9sk1xg6y 6 ай бұрын

Do u have videos on power pivot

@udaymhaskar580 3 жыл бұрын

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.

@Freemarkets1236 Жыл бұрын

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

@piyushrana3080 9 ай бұрын

When I click on "close and load to..." Only two options are shown in the box, Table and Only create connection. PivotTable Report and PivotChart options are missing. I am using Excel 2016. What is the problem?

@mocosta 3 ай бұрын

Could I create a column named as te table name, automatically?

@abhishek051982 3 жыл бұрын

Hi I am facing similar problem but I need to combine sales data from 1 master file to multiple 4 files with selected columns. Is it possible ? Pls help

@aqibjaved6907 3 жыл бұрын

sir while am selecting the append option am not getting option three or more tables its showing single table option am using 2016 version

@akashdeshmukh116 4 жыл бұрын

Hi Sir, After loading data in power query I'm not getting query name directly as region name. I have to do it manually. Can u please tell me why or I'm missing any step? Thanks in advance

@aqibjaved6907 3 жыл бұрын

any one please suggest me