Thread: List all values corresponding to another column

Hi all,
So here's my predicament... I have a column with hours logged by users and another column of the usernames.

There are duplicates of users because this excel logs each time a user logs on. For example 35rtuser could be listed 3 times with multiple logon durations.
35rtuser 45
35rtuser 33
35rtuser 22


I need to lookup each user and then list all of their hours in one cell like this:
35rtuser 45, 33,22

Any ideas?
Thanks,
AG

This is possibe, particularly if you're okay with there being "helper" columns. Do you have a small version of your SS you can post? Easier to work with an existing file rather than having to create something from scratch that doesn't match yours.

As an example, the attached has three helper columns. Data goes in Column A. Enter a user ID in Column F and results are shown in Column G.