• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Get values of multiple occurrences of a unique number


New Member
Hi, I have records in a spreadsheet where I want to be able to get values corresponding to the same unique id from different rows into the same column.
I am attaching the dummy data file for better understanding of the question.



New Member
Thanks a lot bosco_yip, would it be possible to explain what the formula does? Because I have to use this for a lot more columns in the actual data that I have. Would really appreciate if you could detail this out...


Well-Known Member
Would a slightly different output be acceptable?
This is a very simple pivot table, created in about 10 seconds: