transposing layout to table format

[Fawn Lagimodiere]

Hi

I have a file like table 1 how can I get the list of applicants to show
horizontally in a table eg table 2 without using a macro?

Any help would be great

thanks

Table 1
Acct name applicants
123 john applicant 1
123 mary applicant 2
111 jack applicant 1
222 Peter applicant 1



Table 2
Acct Applicant 1 Applicant 2
123 John mary
111 Jack
222 Peter

 

[Claus Busch]

Hi,

Am Sun, 13 Oct 2013 12:06:58 -0600 schrieb Fawn Lagimodiere:

Table 1
Acct name applicants
123 john applicant 1
123 mary applicant 2
111 jack applicant 1
222 Peter applicant 1

Table 2
Acct Applicant 1 Applicant 2
123 John mary
111 Jack
222 Peter

have a look:
https://skydrive.live.com/#cid=9378AAB6121822A3&id=9378AAB6121822A3!326
for the workbook "Transposing"


Regards
Claus B.

 

[Claus Busch]

Hi,

Am Sun, 13 Oct 2013 20:48:34 +0200 schrieb Claus Busch:

have a look:
https://skydrive.live.com/#cid=9378AAB6121822A3&id=9378AAB6121822A3!326
for the workbook "Transposing"

rightclick and download the workbook to see the formula


Regards
Claus B.

 

[Fawn Lagimodiere]

thanks this is exactly what I am looking for. Is there a formula I need to
use?

 

[Claus Busch]

Hi,

Am Sun, 13 Oct 2013 13:12:04 -0600 schrieb Fawn Lagimodiere:

thanks this is exactly what I am looking for. Is there a formula I need to
use?

if you download the workbook, you see the formula.
It is an array formula to enter with CTRL+Shift+Enter
The formula in G2:
=IFERROR(INDEX($B$1:$B$10,MATCH(G$1&$F2,$C$1:$C$10&$A$1:$A$10,0)),"")
Copy down and to the right


Regards
Claus B.

 

[Claus Busch]

Hi again,

Am Sun, 13 Oct 2013 21:18:33 +0200 schrieb Claus Busch:

if you download the workbook, you see the formula.

have another look for the workbook in SkyDrive.
I put another suggestion in it.


Regards
Claus B.

 

[Fawn Lagimodiere]

Thanks so much this is exactly what I am looking for

Fawn