Thread: using data from one column to generate new columns
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
manyquestions manyquestions is offline
external usenet poster
  
Posts: 2
Default 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 ?
Reply With QuoteReply With Quote