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