1 min readfrom 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

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:

https://preview.redd.it/9yr97qphrhng1.png?width=206&format=png&auto=webp&s=d14f8f701b0529a2835ddd8ee02e6d5e1045384a

submitted by /u/dogmom8008
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#Excel alternatives for data analysis
#generative AI for data analysis
#natural language processing for spreadsheets
#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
#rows.com
#modern spreadsheet innovations
#machine learning in spreadsheet applications
#enterprise-level spreadsheet solutions
#digital transformation in spreadsheet software
#Excel compatibility
#collaborative spreadsheet tools
#AI-driven spreadsheet solutions