Get values of multiple occurrences of a unique number

[excel_gyaan]

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.

 

[bosco_yip]

Try...........

In G9, formula copied across and down :
=OFFSET($A$1,(0+RIGHT(G$8)=2)*10+$F9,INT((COLUMN(A$1)-1)/2)+1)

 

[excel_gyaan]

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...

 

[p45cal]

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