Combine Data from Multiple Sheets in a Single Sheet

Chanddep, I just consolidated a massive file that was related to a 100 Million dollar project! Kudos brother!!

Thanks, what if the number of rows in consolidated sheet becomes greater than 1 mio?

Dear Chandeep would you please give an example power query using medical students data, I am badly need to understand it

Too confusing to follow the steps 😞

Thanks bro save my time alot

How do we do same in excel 2013 , ??

Thank you very much for wonderful explain

Hi chandeep, when i will refresh all data will loaded double the time

Thank you my bro Chandeep from Bangladesh

How can we do this when we have to fetch all the data from same excel workbook we are working on?

I have a column which contains external links or hyperlinks. While I combine them into master sheet, only the text is copied in that cell, the hyperlink isn't getting populated in master sheet.


Any way to fix this?

Hey

I am unable to open Power Query Editor from excel.. any settings that I need to do?

Thank you it works😊

Thank you, this is very helpful!

How to do if it is required to transpose data (with both attributes and date for a month) for each sheet and combine each sheet (in monthly basis) in power query? FYI...The headers are on row side.

Thanks a lot for this video. Is possible to just merge the first 100 data from each sheet?

Hi, Thanks. Pls explain how to consolidate the data from Multiple Excel files.

Hi this is great but for some reason when i use tables to do this it is not refreshing?

Thank you so much.. perfectly explained!

Hi Chanddep! Thank you for your tutorial. I have a question, I have multiple reconciliation sheet which I would like to summaries the balancing total. Do you have a solution?

good

😊 🎉 you always serve the best tutorial for complex function of power query. Thank youuu for your enthusiasm to share your knowledge!

What to do if there's an error ?

Thank you

What to do after 1sheet get full

awesome video! thanks...saved me so much time!

Thank you!!

I have been searching for a way to do this, Thank YOU!

DAMN, This was AWESOME thank you bro

Appreciate the demo

THANK YOU! MY FIRST TIME CONSOLIDATING MY FILE INTO ONE WORKBOOK. THANK YOU A LOT!

I need your assistance with merging a bit of a complicated file

Hi Chandeep, your demo is excellent and i am not finding get data option, please guide me...

When I try to consolidate the contents of other sheets to a blank sheet "Consolidated Data" which is in the same file it gives me the error as soon as I click the Transform button as "The process cannot access the file 'D:\OneDrive\OneDrive \Desktop\File Name.xlsx' because it is being used by another process."

However if I chose the source as another file it allows me to proceed.

Legendary video, thank you so much!

Thanks. Watched many other videos. Your solution is simpler & quicker. That works. Thanks!

this was fantastic

and instead adding new query from each table manually how to automate the process

Hi Sir, I don't want to combine the data instead would like to generate multiple tables from single query

I get a "already open" popup when after selecting the file name that I'm already working in.

I just tried to do this- Get Data/select From File/select From Excel Workbook and I got an error message saying that the file is in use by another process. I am trying to use a new tab in the source files to consolidate all tabs into one consolidated tab in the same file, which I've read is possible but I keep getting that error. Any ideas?

Wonderfull explanation. You speak very fast. I need to pause and rewind. Lots of information. Thanks!

I get this message when I try to Get Data: Details: "The process cannot access the file 'C:\Users\Computer\OneDrive\Documents\filename.xlsx' because it is being used by another process."

Hi Chanddep, I am getting the following error when I refresh " Datasource.error The process cannot access the file because it is being use by another process"

Thanks a lot Chandeep