View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
HearSay HearSay is offline
external usenet poster
 
Posts: 4
Default Need to combine data programatically.

Here is my spreadsheet

369 Medical Authorization/Utilization
370 Apportionment
370 Settlement
371 Apportionment
371 Settlement
372 Apportionment


For my final results I would like to see

369 Medical Authorization/Utilization
370 Apportionment, Settlement
371 Apportionment, Settlement
372 Apportionment

So I a column has a duplicate value, I would like to combine those into one
row and delete the row after combining. There could be more than two
matches.

Any ideas on how to do this?