•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Combining Tables that feed from another data set
Our take
Combining tables from multiple data sets can streamline your vehicle usage tracking, providing valuable insights into departmental activity. To create an automatic usage tracker, using Power Query is indeed a powerful approach. It enables you to consolidate your weekly data into a comprehensive monthly overview. If you're encountering error messages, it may be due to data formatting or connection issues. Let's explore how to troubleshoot these errors and successfully merge your tables, transforming your data management process into a more efficient and insightful experience.
I have an Excel sheet that tracks when our company vehicles are used by different departments. I am trying to create a table that would serve as an automatic usage tracker, which will tell us how many days per week and month each department uses the vehicles. I have the data being input into the attached tables per week, a copy attached here. But I cannot figure out how to combine these tables into one data set for the entire month.
Please help me! I have been researching, and it sounds like I should be using a Power Query? But when I have tried, it always gives me an error message.
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Consolidate data from different worksheets with final information coming from a combination of the worksheetsHoping for some help on a problem I can't wrap my head around. I need to consolidate some information from 12 different tabs (one data pull per month) into one worksheet with some of the data needing to be overridden and some needing to stay. With the most recent pull of the data not necessarily being the information I want showing, I'm not sure how to proceed. I'm trying to find a way to create this and pass it along to someone else to just load data and it automatically puts out the result I'm looking for. For instance, I pull information from my system in January for the entire year (broken into monthly buckets) and all of that is perfect. My second data pull of the year in February isn't so clean. I need to see the numbers from January on any of the January data (because it zeros out in February in my system) but everything related to February through December needs to be from the most recent data pull. Third pull of the year in March, I need to see the numbers from January and February for the January and February data and then need the new info for March through December. Basically, by the time December rolls around, I need data from all 12 sheets. Hopefully this makes sense. Any thoughts on how I can accomplish this in Excel? submitted by /u/megd726 [link] [comments]
- I need a way to combine multiple workbooks to use in a pivot table that can be refreshed through sharepoint.I have 5 spreadsheets in a folder on sharepoint and one on a separate folder in the same team site. These track contacts made by clients. Each workbook is for a LGA (location) and have the same structure. they have a sheet for each month and a table for that month. I initially struggled to use the Sharepoint Folder to combine these so created queries in Power Query. for each workbook I created a query which combined the 12 tables and then created a query which appended them. I was able to put this in a workbook and a pivot table to summarise where we were up to. it worked really well. the permissions were set using organisational account. this lasted about a day and now I cannot refresh it. I can refresh in the power query editor but not in the spreadsheet. I have opened it in the desktop version and also the same problem. I am now getting errors about legacy connections. I then tried the Sharepoint folder which finally worked but seem I can combine the January tables for the five spreadsheets but then I would need to do the same for each month. I would love any suggestions for this to consistently work and refresh from our sharepoint site (excel online). submitted by /u/Eastern_Echidna5680 [link] [comments]
- How to merge tables from different files on one single excelhello! I'm no Excel connosieur, so I'm turning to this subreddit for some help! I have 12 files on my computer (one for each month of the year 2025) who each contain between 10 to 12 Excel documents. In total, I have approximately 132 Excel books that I need to merge into one single Excel. All of these Excel files have the same table format, except for maybe 5 that contain the same information as the rest. The rows, instead of being in the same order as the others, are mixed up. I've tried using Power Query, but half of the Excel files I import come up empty/only bring half of the information. Does anyone have any recommendations/YouTube video tutorials, or some tips/tricks to tackle this as quickly as possible? I'm sure anything is faster than just copying and pasting everything manually. Thank you for reading!! submitted by /u/mirapxoxo [link] [comments]
- Power query and manual table next to itHi, I want to pull data verbatim from a spreadsheet my team uses and use data from it for my own purposes. The main goal for using power query is that the data updates on my spreadsheet. Mainly, if any new entries are added at the bottom. I also have some manual fields that I need to add that correspond with the power query data. I've added another table beside the power query data, and filtering it causes the data on both sides to adjust correctly. I'm mainly concerned that, if the entries are rearranged or sorted on the original sheet, that my tables will not align after a refresh. Also, if a refresh would break my table alignments at any point. Is my fear founded? Is there a way to combine the two features that I need into a single table? submitted by /u/Perspective-Guilty [link] [comments]
Tagged with
#Excel alternatives for data analysis#generative AI for data analysis#big data management in spreadsheets#conversational data analysis#real-time data collaboration#intelligent data visualization#data visualization tools#enterprise data management#big data performance#data analysis tools#data cleaning solutions#Excel compatibility#rows.com#Excel alternatives#natural language processing for spreadsheets#Excel#Power Query#data set#vehicles#combine tables