Combining several files into one, matching by date and time
Our take
Hello fellow excel nerds! I need some help
I currently have data coming from several different sensors in several different csv files. Each operates on its own schedule and measures different variables. I’d like to combine them all into one master sheet, where for each time and date I have the output from each sensor.
I’m sensing power query is going to be what helps me, but I haven’t quite sussed it out yet. Part of the difficulty is that the columns are named differently as the sensors measure different things (like luminosity, speed, humidity, location), and, of course, they operate on different timelines. So for example one sensor will measure every minute, another every hour, and yet another measures only when specific events happen so those timestamps are basically random.
What I’m trying to get is a master table that would tell me at 9pm, the speed was x, the humidity was y, the location was z. I understand I will have a lot of blank values at timestamps where only one or two sensors recorded data points, but I can live with that.
Does anyone know how to do this, or even know the accurate term for this manipulation to help me in my research?
Many thanks!
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Combining Tables that feed from another data setI 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. submitted by /u/Clear_Yesterday9807 [link] [comments]
- 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]
- 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 for a large datasetMy company uses a horrible format for its daily production sheets, but the data can be pulled through power query. I want to build a reporting tool for looking at any major trends that are currently missed. Ideally looking at part efficiency by machine type and some other descriptive data too like efficiency by shift manger etc. My problem is that even after cutting unnecessary columns and filtering unnecessary rows, it takes forever to load anything. ChatGPT isn’t all that helpful, I’d like some expert advice please! For info, rough number of rows of data is about 50,000 per year. I want to cover at least the last three years. Sheets are all saved into a folder by month, within a folder by year. submitted by /u/CanJesusSwimOnLand [link] [comments]