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...
Hi,
The only issue with this is, my tables look like this
https://ibb.co/MBB7NBX
and each worksheet is monthly data. So when I upload them individually to a query, I'm extracting the first column name to create a client column and adding a new field to include which month the table is from. The month information is in the table name, example: clientABC_july22, but I have not been able to import.
So essentially the reason I'm uploading each table individually is so I can include the client name and month of the table into the data so that I can differentiate this data when I eventually append it all into one big table.
The only issue with this is, my tables look like this
https://ibb.co/MBB7NBX
and each worksheet is monthly data. So when I upload them individually to a query, I'm extracting the first column name to create a client column and adding a new field to include which month the table is from. The month information is in the table name, example: clientABC_july22, but I have not been able to import.
So essentially the reason I'm uploading each table individually is so I can include the client name and month of the table into the data so that I can differentiate this data when I eventually append it all into one big table.
https://www.linkpicture.com/q/tables_1.png
Apologies for the bad link.
Apologies for the bad link.