• 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

    Hui...

  • 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

excel_gyaan

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.
 

Attachments

  • Dummy data.xlsx
    10.1 KB · Views: 4
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...
 
Would a slightly different output be acceptable?
This is a very simple pivot table, created in about 10 seconds:
65383
 
Back
Top