•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Combine all dates for a given user into a single cell
Our take
Managing large datasets can be daunting, especially when you need to consolidate information efficiently. In this scenario, you have over 4,000 lines of data with multiple entries for user IDs and corresponding dates. Your goal is to streamline this information by combining all affected dates for each user into a single cell, separated by commas. This approach not only enhances clarity but also simplifies your analysis, allowing you to quickly assess the impact on each user without sifting through individual entries.
I have a spreadsheet with over 4000 lines of data. User IDs are listed in one column and there are duplicates, there may be multiple dates per user. I need a way to easily say, for user x, these are the dates that were affected by this issue, without having to go user by user. Ultimately I'd like all the dates for each user to appear in a single cell, separated by commas.
This is what the data looks like:
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Any way to automate removal of older rows of data?I have a spreadsheet with 4 columns: first name, last name, score and date. I have people who are duplicated, some with the same date which I can easily remove with "remove duplicates" but I have examples where there are people with multiple rows from where they have taken a test a few years later, and i am trying to find a way to optimise my chopping up of this spreadsheet to only have a single row per user, and showing only their most recent score for the test. The date column is dd/mm/yyyy and then a 24 hour format time stamp and I can't think of a good way to optimise that as it covers multiple years. Theres no good consistency over the old date and the most recent date I imagine excel has some way of pruning older data. Atleast I hope so or ill have to check 50000+ rows manually to remove old results 😭 submitted by /u/Skellyhell2 [link] [comments]
- Is there an easy way to auto-add multiple rows with the same data in a spreadsheet?We have a tracking spreadsheet that we update twice a year. On the spreadsheet, there are repeating lines of 6/15/25 and 11/15/25. We need to add in a row with the date 6/15/26 under every single 11/15/25 line (hundreds of them). I was curious if there is some sort of formula or way to add all of these rows with the date all at once. The spreadsheet follows a pattern so the 6/15/26 line would always follow the 11/15/25 row and always be every third line in the data set. If not, I might just be adding and copying/pasting for a while but thought I’d see if there’s a trick anyone knew of. submitted by /u/GroundbreakingBath40 [link] [comments]
- Combining several files into one, matching by date and timeHello 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! submitted by /u/Mysterious_Camel_717 [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]