using data from one column to generate new columns
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 ? |
using data from one column to generate new columns
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 -- Gary's Student gsnu200709 "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 ? |
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 ? |
All times are GMT +1. The time now is 10:16 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com