View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
tomhelle tomhelle is offline
external usenet poster
 
Posts: 24
Default Create summarized list from larger list

I have a long list of various components that I want to summarize. For example:

Column A Column B
Material 1 Thickness 1
Material 1 Thickness 2
Material 2 Thickness 1
Material 1 Thickness 1

I want to summarize this data so that it will produce a list as follows:

Column A Column B
Material 1 Thickness 1
Material 1 Thickness 2
Material 2 Thickness 1

Many thanks in advance!