using data from one column to generate new columns

[Guest]

Hi

I want to do the following:

make

A 2 x
A 2 y
B 2 x
B 2 y

into

x y
A 2 2
B 2 2

How do I do it ?

 

[Guest]

If you want to make a two dimensional table from columns, then try a Pivot
Table:

for example, starting from:

Alpha value beta
A 1 x
A 3 y
B 5 x
B 7 y
B 13 z
A 2 w

In A1 thru C7 we can make:

w x y z
A 2 1 3
B 5 7 13

See:

http://peltiertech.com/Excel/Pivots/pivotstart.htm

 

[Guest]

Assuming your data in A1:C4

your criterias
In E2: holds "A"
In E3: holds "B"
In F1: holds "x"
In G1: holds "y"

=INDEX($B$1:$B$4,MATCH(1,($A$1:$A$4=$E2)*($C$1:$C$4=F$1)))

ctrl+shift+enter, not just enter