Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 ? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 ? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 ? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Merging multiple columns of data into one column of data | Excel Discussion (Misc queries) | |||
generate a random number and use if function to generate new data | Excel Worksheet Functions | |||
Generate column of 1's and 0's randomly | Excel Discussion (Misc queries) | |||
Generate a graphical formula from a column of data | Excel Discussion (Misc queries) | |||
Comparing columns iin 2 sheets to generate one | Excel Worksheet Functions |