View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mike Mike Mike Mike is offline
external usenet poster
 
Posts: 7
Default Is it possible to do this?

Is it possible to move column B fields to the row with matching content in A

From this:

A B
bananas yellow
oranges candy
pigs bananas
cows blue
candy
blue
red
yellow

To this:

A B
bananas bananas
oranges
pigs
cows
candy candy
blue blue
red
yellow yellow


Regards
Mike