using data from one column to generate new columns
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
"manyquestions" wrote:
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 ?
|