View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
rodchar rodchar is offline
external usenet poster
 
Posts: 80
Default 2 columns processing

hey all,
i have 2 columns
categories and products

home,furniture
home,household
car,fuel
car,service

is there a way to put above in following format in a new column?

home
furniture
household
car
fuel
service

thanks,
rodchar