Forum Discussion
Best way to combine 400 small tables in Excel?
I have about 27 worksheets with 15 smaller tables on each worksheet that I need to connect into one major table to eventually create a dashboard. I used Power Query to do this. So far I've reached 17...
JigyasaI thought you had 27 workbooks, each with 15 tables in it. So, you have one workbook, with 27 sheets in it, each having 15 tables on it?
And my I presume that the tables are structured Excel tables.
If so, then connect to the workbook. Select the workbook name in the Navigator and press transform.
In the next screen you can, for example, filter all rows where the Kind is Table and then expand the Data column.
If all of this does not make sense, explain how you are currently connecting to all the tables. Include screenshots like the ones above, showing the steps you take.
This is essentially what I've done just that I've gone the long route and added it table by table but I'm not sure if it can refresh any faster