Assumptions:

A1:C1 contains the headers/labels for the source table

A2:C6 contains the data for the source table

E1:H1 contains the headers/labels for the results table

E2:E3 contains the server ID, such as 1 and 2

Formula:

F2, copied down and across:

=IF(COLUMNS($F2:F2)<=COUNTIF($A$2:$A$6,$E2),INDEX($C$2:$C$6,SMALL(IF($A$2
:$A$6=$E2,ROW($A$2:$A$6)-ROW($A$2)+1),COLUMNS($F2:F2))),"")

....confirmed with CONTROL+SHIFT+ENTER, not just ENTER.

Hope this helps!

In article <4CD7BD7B-EA17-4663-8DF8-E0459BE352C4@microsoft.com>,
MsNadi <MsNadi@discussions.microsoft.com> wrote:

> I'm going to provide as much information as possible.
>
> I have an array of data with multiple records mapping to a single reference
> ID. I am trying to create a listing of application hosted on a single
> server, by server id.
>
> Example:
> Server ID ApplicationID Applicationname
> 1 1.1 AAA
> 1 1.2 AAB
> 1 1.3 AAC
> 2 2.1 BAA
> 2 2.2 BAB
>
> What I want is to reverse the listing so that each server has a single
> record with a horizontal listing of applications following as follows:
>
> Server Application1 Application2 Application4
> 1 AAA AAB AAC
>
> I know that this is currently not possible using either of the Lookup
> functions as they will only return the first instance upon matching the
> criteria. Is what I'm trying to do possible in Excel, and if so how?
>
> Thanks.