how to combine all sheets in power query

Question

how to combine all sheets in power query

slardar22 0

User's image

1 answer

Your answer

Answer 1

Jing Zhou 7,765 Microsoft External Staff

Hello,

Thank you for posting in Q&A forum.

I have found a relevant solution for you. Please let me know if this is what you are looking for

Combine Data from Multiple Sheets in an Excel file with Power Query (mssqltips.com)

Please Note: This response contains links to third parties, which we provide for convenience of reference, and Microsoft cannot guarantee the validity of any information and content in this link.

Best regards，

Jill Zhou

If the Answer is helpful, please click "Accept Answer" and upvote it.

Jiajing Hua 18,060 Reputation points Moderator

2024-07-12T02:04:24.53+00:00
Hi @slardar22

Please refer to Jing Zhou's sharing link. In this link, there are 3 methods to combine all sheets in a query.

Create connection queries to the data in each sheet and then combined all via Append Queries as New command.

If the workbook may have new worksheets, you may create a connection query to the workbook instead of each sheet. After process the data, then expand a Table-Structured column.

Use = Excel.CurrentWorkbook() to establish a connection to the current workbook. By this way, the workbook could provide an overview of the raw data.
Jiajing Hua 18,060 Reputation points Moderator

2024-07-22T06:11:57.33+00:00

Hi @slardar22

Sorry to bother you, just want to check whether our information is helpful to you.

Any further issues, welcome to post back.

Share via

how to combine all sheets in power query

1 answer

Your answer