Complex VLOOKUP, multiple instances vertical, return subsequent instances horizontally

Data source.PNG
Destination sheet.PNG

Have been stumped on this one. Any help and guidance appreciated.

I have a number of sheets and am looking to consolidate the data in to a mastersheet. This master sheet has unique values in left most column and is used to identify, source and retrieve data from other sheets.

There are number of instances where I am trying to retrieve multiple instances of associated data and deposit horizontally on a different sheet i.e. a unique asset (computer) has multiple drive letters. VLOOKUP only retrieves the first instance.

Have attached image of source and destination sheet and the formula I am currently using. Would really appreciate some guidance here

Here is one way how to accomplish this:
http://www.get-digital-help.com/2009...xcel/#horizont

If you post your workbook I can implemnt this formula.

Thanks dewilk, that was sufficiently concise for me to understand and implement. Now am just trying to figure out how to combine that with a count i.e. If a value appears multiple times, how to return the aggregate number.

Is this a qustion or assumption?

sample_v3.xlsx
hi RobertMika

i have a similar problem as the one on get-digital-help.com, but noting there exactly solves my problem. maybe you can help?

i have a big table and i need to filter out the late payments. the late payments are categorized into how late they are.
the filtered list should show the clients with late payments per category and omit clients without late payments.

in the attached sample sheet, the cells in red are my problem: the formula always shows the same client, instead of going down the table and looking for others that have late payments.

any ideas?

thank you!